April 6, 2008 at 9:20 am
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?
April 6, 2008 at 12:45 pm
If existing data and log files for all databases are ok then You should use data and log files for system databases after installing sql server provided you are installing it as same instance and if your data files and log files for user databases are at same location as it was before. It will be done in three steps:
1. stop sql services.
2. Move new data and log files for system databases and copy old one at new location
3. start sql services.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply