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