September 4, 2003 at 9:07 am
I had to rebuild our server that hosts MSSQL Server databases. None of the .mdf and .ndf files were harmed; so I figured I just had to reinstall the SQLServer2000 software, since all of the data was still on the server. After I did so, all of the databases that did not use filegroups were OK, but the databases that do use filegroups were marked as 'suspect.' The filegroups are all located on the hard drive of the server, outside of the "C:\Program Files\Micrsoft SQL Server" directory. Might anyone have a suggestion for how to restore these databases from the .mdf/.ndf files? Many thanks in advance.
September 4, 2003 at 9:19 am
Take a look at sp_attach_db in books online.
It may be what you are after.
Steven
September 4, 2003 at 2:36 pm
The sp_attach_db solution worked! Thank you very much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply