sp_resetstatus not working?...

Hi:
I tried to restore a database and get 'suspect' gray sign on it and found in the error.log of "Bypassing recovery for database 'DBxyz' because it is marked IN LOAD."

Then, I tried the following T/sql:
sp_resetstatus DBxyz

and got following response from exec:
Prior to updating sysdatabases entry for database 'DBxyz', mode = 0 and status = 4194361 (status suspect_bit = 0).
No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.

after I drop it, and restore again, it works. I remember that sp_resetstatus worked fine in the SQL6.5, but not so in sql2000....

thanks
David

It just changes db status but doesn't fix any problem, still have to restore from backup.

So, the suspect status if happen during the restoring, it is a mssql issue, sp_reset won't help.

While a suspect status for an existing database, the sp_reset should be useful to take off the suspect status.

thanks for the info rmiao
-D