November 13, 2002 at 4:47 pm
Hi everyone, our database architecture is set up so that our data is on RAID 5 and our indexes are on a single drive with no RAID. I was told that if the index drive fails I would not be able to recover the database (to the point of failure of course).
Is that true and if so, what are some ways that I can protect my index filegroup? Any ideas would be appreciated. Thank you.
November 14, 2002 at 2:46 am
Put them on a raid drive. No other way I know of protecting them
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 14, 2002 at 2:46 am
Put them on a raid drive. No other way I know of protecting them
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 14, 2002 at 4:50 am
Also, look at the details on filegrups, make regulare backups of this filegroup and you can restore it if lost. However, it will have to be restored to the same path exactly and the DB will not work until it is back.
Otherwise Simon is a much better answer.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply