What can be done to recover a database that has been marked "suspect."
I know this is a loaded question, so here are the details;
The client had a hardware failure and after resolving the failure, in
recovering their databases discovered they had only been backing up the .mdf
files, and not their associated .ldf files.
When Enterprise Manager is brought back up, the database is marked
"suspect," likely due to the missing logfiles. What can be done to get the
database back to a consistent state at that point?
Thanks in advance for any input.
- JohnHi John,
The best option is definitely to restore from backup. However if that is
not possible or desirable, I suggest you to call Microsoft Product Support
since it could be complicated depending on the extent of the damage.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
