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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-10-28 : 08:00:40
|
Manu writes "Hi all,I have a database in MS SQL Server 2000 (SP3). In Enterprise manager it shows status as "Suspect". I restarted the server but the status remained unchanged.Then I finally stopped the server and took the backup og MDF and LDF files of the database and after starting server I deleted it.Now I have only data files and want to recover it on urgent basis.Can anyone tell the solution to it.ThanksManu " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-28 : 08:06:07
|
| For one, you should've first looked in Books Online under "suspect". You would have found an entry that describes a system procedure called sp_resetstatus. That would have allowed you to attempt recovery of the database without detaching or dropping the database. You can try attaching the database and log files with sp_attach_db, also detailed in Books Online. However, since the files were not detached properly they may still be corrupted and won't attach correctly. If you do get them attached, run DBCC CHECKDB on it IMMEDIATELY, and do NOT allow anyone to access the database until you are done checking it. You can do this by setting the database to single user mode, and again, this and DBCC CHECKDB are listed in Books Online. |
 |
|
|
|
|
|
Recover MS SQL Server 2000 (SP3) Data files