Have you encountered this error “spid13 Bypassing recovery for database ‘yourdb’ because it is marked SUSPECT”. One of my friends got this error on his SQL Server 2000 database. This error usually occurs when SQL Server is not able to access a database
If you plan to recover a corrupt database on your own, here are some simple solutions that may work:
1. Run this command
SET status=status & ~256
WHERE name= 'yourdbname'
2. If that does not solve the problem, here’s a way to do it in emergency mode (untested)
UPDATE master.dbo.sysdatabasesIf you know of any other way, drop in a comment. Thanks!
SET status = status -32768
where name = 'yourdbname'
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|