Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MSDB database not responding Expand / Collapse
Author
Message
Posted Monday, November 12, 2012 5:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 14, 2016 9:06 AM
Points: 157, Visits: 942
Sql server 2000

I am getting below error, when i start backup

Backup database cannot be used on database opened in emergency mode.backup database terminating abnormally.

SQLServer Error: 3908, Could not run BEGIN TRANSACTION in database 'msdb' because the database is in bypass recovery mode. [SQLSTATE 25000] (ConnIsLoginSysAdmin)


Please any one help me.


Thanks
solomon
Post #1383641
Posted Tuesday, November 13, 2012 5:50 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 6:24 AM
Points: 1,468, Visits: 3,410
Check the SQL Server logs for what else might be going on. Are other databases in an odd state? Did you restart the server and msdb go into this mode? Check the Windows Event logs as well.

You probably are going to have to restore the msdb database to a good backup.



Post #1384047
Posted Tuesday, November 13, 2012 7:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, January 15, 2016 7:34 AM
Points: 2,308, Visits: 1,371
Do you have a backup of the msdb database to restore to?

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Post #1384101
Posted Tuesday, November 13, 2012 7:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 13,971, Visits: 36,263
duplicate post.
no need to cross post to multiple forums; it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
SQL SERVER AGENT SERVICE NOT STARTED


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1384106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse