-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|