Monday, March 26, 2012

Need suggestion for BACKUP and Database files on RAID 5 configuration....!

I have RAID 5 with 1 logical drive with 2 partitions with SQL Server 2000 running on SERVER.

what best model for data storage and backup would some experienced one suggest:

basically I want to put Master, Database files and T-Log files away from each other.

-- Data files
-- Log files
-- Master database.

Thanks,

Fahim.

1.For data storage you can put in first partition the SQL software and in second the data, depends on the size of each ;in fact doesn't matter the configuration of data because the availability is supplied by RAID 5, more for same reason you can put all user and master databases in same place !

2.For backup you must storage the data out of this server using tape cassetes or a hdd in the network.

No comments:

Post a Comment