Hewlett-Packard began manufacturing personal laptop computers in 1993.

1624 Questions View all

How to restore a database from the suspend mode?

Died msdb database. Went to this interesting mode.

Backups of the database, but how to recover the database can't understand because the database is in suspend mode.

I tried to put it into EMERGENCY mode but get an error

Msg 5058, Level 16, State 6, Line 2

Option 'EMERGENCY' cannot be set in database 'msdb'.

And how with it to struggle??? what are the options?

Answered! View the answer I have this problem too

Is this a good question?

Score 1
Add a comment

1 Answer

Chosen Solution

Come in here and read the information on this issue.


Personally, I can advise to do so:

Try running the server in exclusive mode sqlservr.exe -m-c. And is farther by means of SQLCMD.

Was this answer helpful?

Score 1


Thanks for the help! solved!


Add a comment

Add your answer

alainmarion85 will be eternally grateful.
View Statistics:

Past 24 Hours: 0

Past 7 Days: 0

Past 30 Days: 0

All Time: 101