Link to home
Create AccountLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

MS SQL Server return from Emergency Mode

I had a database I could not access until I set it using the following...

ALTER DATABASE emergencydemo SET EMERGENCY;
    GO
ALTER DATABASE emergencydemo SET SINGLE_USER;

How do I get it back to normal mode?
ASKER CERTIFIED SOLUTION
Avatar of Russ Suter
Russ Suter

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Larry Brister

ASKER

Thanks
Avatar of Russ Suter
Russ Suter

I should emphasize that data loss IS a possibility with this command.

You could first try
DBCC CHECKDB (emergencydemo, REPAIR_REBUILD) WITH NO_INFOMSGS;
GO

Good luck!