I recently stumbled across some old commands to remove the db status from 'suspect' or 'restoring', although I would always recommend using restore database with recovery initially to remove the recovery issue.
These are :
- sp_resetstatus
- DBCC DBRECOVER (database) - Removed from SQL 2012
These should not be your first option but when all else fails...
No comments:
Post a Comment