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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-04-06 : 11:22:23
|
| I need to recover an entire named instance because of data corruption on the SAN. The DBs are OK but the SQL Server Service will not start due to a 'windows internal error' so I'm going to restinall the instance. I have all of my data and log files from all databses including the master.. can I use these to recover or is a restore of system databases better??Also, I have a database with 5 .ndf files. I can't quite get the syntax right to attach these files after I do a restore to get the LATEST data? Can anyone help? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-06 : 11:38:24
|
| Do you have backup of all databases? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-06 : 16:18:22
|
| If all db files are in good shape, you can install sql with same version and sp level on same directories as previous. Then stop sql, replace system db files with files you have, put user db files in place and start sql again. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-06 : 17:33:55
|
| I am not sure they will get attached. It would be good if you had good backups. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-06 : 18:00:52
|
| Yes they will if have right master db, just another option than restoring from backups. |
|
|
|
|
|
|
reinstall sql server 2000 Ent edition named instan