Restoring a SQL Server database marked as suspect

Restoring a SQL Server database marked as suspect: "from Sql Server Blog by noreply@blogger.com (Suprotim Agarwal)

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

UPDATE master.dbo.sysdatabases
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.sysdatabases
SET status = status  -32768
where name = 'yourdbname'

If you know of any other way, drop in a comment. Thanks!

"