Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
druer
Constraint Violating Yak Guru
314 Posts |
 Posted - 2006-01-16 : 15:46:21
|
| I haven't come across anything which would tell me for certain what would happen if I move some of my hardest hit (non-clustered) indexes to a Secondary Filegroup that is on a new (non-raided) hard drive that was added to the server. I am using SQL Server 2000 on a Windows 2000 box. Currently the database resides entirely on a large raided device.In the even of a drive failure ...Would the database continue to run without the indexes on that drive?Would the database stop running because those indexes would be in accessible? |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-01-17 : 03:23:33
|
| I'm not certain of the answer to your questions but my question to you would be "Are you prepared to risk it with your data?"steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-01-17 : 04:23:24
|
| Correct me if I'm wrong, but I think in the case of drive failure, since your index is in the non-raided drives, your DB will not come up at all as its missing data, but if only non-clustered index is there, you might be able to repair it? I'm not too sure, you might can test it out :) |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-01-17 : 08:47:08
|
| elwoos - I'm not willing to risk it, that's why I was asking for input from others who already did tests or know positively one way or the other. Westley - I'm thinking I may need to do the tests as I haven't received any positive feedback of "no problem. the database will continue to run and those indexes will just be ignored." |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-01-17 : 10:48:04
|
| You will not be able to access you database.CODO ERGO SUM |
|
|
|
|
|
|
Indexes on Secondary Filegroup