1

In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to run because the database is in this mode. What to do in this case?

2
Contributors
1
Reply
6
Views
2 Years
Discussion Span
Last Post by GervaseParrish
1

First it is necessary to transfer a database in EMERGENCY mode:

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY

Then to carry out testing of base:

DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

On this resource too there are useful recommendations. See if the following article would help:
https://answers.yahoo.com/question/index?qid=20140723064050AAy1G2P

Edited by pritaeas: Added markdown.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.