Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, August 14, 2014 12:40 AM
Points: 152, Visits: 818
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 1,269, Visits: 2,781
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 11, 2014 7:00 AM
Points: 1,746, Visits: 1,323
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 @ 1:24 PM
Points: 12,906, Visits: 31,984
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1384106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse