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 |
|
jreyst
Starting Member
9 Posts |
 Posted - 2004-04-28 : 11:58:31
|
| I have a serious situation. I have 2 filegroups on my database, PRIMARY and INDEX. Last night, we had a complete failure of the drive with the INDEX filegroup. We had it, conveniently enough, right at the time the tape backups were being run.The INDEX filegroup stores the indexes only. The PRIMARY filegroup contains the tables, none of which have a clustered index. Is there a way for me to bring the DB up with just the PRIMARY filegroup? I tried sp_attach_single_file_db but it fails because it tries to activate the other file, which doesn't exist (and is currently being restored from monday's backup)SQL Server 7 (SP3), Windows NT 4.0 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-28 : 12:07:01
|
| Do you have a disk backup anywhere?If so, create a new database and do a force restore on it... |
 |
|
|
jreyst
Starting Member
9 Posts |
Posted - 2004-04-28 : 12:08:39
|
quote:
Originally posted by RickD
Do you have a disk backup anywhere?
No, the drive where the backups go also crashed. |
|
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-04-28 : 13:34:15
|
| Do you have any backups on tape?-JonJust a starting member. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-28 : 13:42:50
|
| Shot in the dark time...Do you have a script of all the objects?You should have 1 DDL for the tables and 1 for the Indexes (or they may be combined).Recreate an empty databaseDump that databaseNow see if you can use that index mdf (or ndf, whatever) in concert with the database mdf....This is a total shot in the dark...I've never done this....But I don't see why not...Just luck it's not the other way around...Redundancy is a good thing...We ship logs every 15 minutes to a disaster box...dump the db nightly and ship it there...I also have the dump shipped to our dev box where a job restores it there as well...Then there's also the dump to tape on prod....good luck...let us know...Brett8-) |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-04-28 : 14:53:55
|
| Unfortunately, it looks like the filegroups are intrinsically linked. I am helping with this problem (co-workers). If they are even the least bit out of sync, the DB won't come up, even though the index filegroup should only really contain the indexes, which could be easily rebuilt.Dammit dammit dammit. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-28 : 15:26:42
|
| It's got to be internal pointers...anything like sp_fix_logins for the objects?Brett8-) |
|
|
|
|
|
|
|
|
Restore single file