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?
ALTER DATABASE emergencydemo SET EMERGENCY;
GO
ALTER DATABASE emergencydemo SET SINGLE_USER;
How do I get it back to normal mode?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
You could first try
DBCC CHECKDB (emergencydemo, REPAIR_REBUILD) WITH NO_INFOMSGS;
GO
Good luck!
ASKER