Hello
(SQL Server 2000)
I have databases that appear as "Suspect" in the Enteprise Manager. What can I do to recover them or put them in a normal state?
Thanks a lot.Depends on why it is suspect. If you are lucky, someone simply moved the database files, and you just beed to move them back. if you have average luck, then you are looking at a database restore. What does the errorlog say?|||before you decide what to do, you ought to determine the cause.
but you can either...
a. you might be able to put your database in emergency mode and extract your data using bcp or dts.
or
b. restore from your last good backup.
I practice full recovery and can recover to any point in time, so I usually go with b and I have never done a, but I hear it is possible in some situations.
No comments:
Post a Comment