Post reply

MSDB database not responding

  • November 12, 2012 at 5:37 am

    #270140

    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

  • November 13, 2012 at 5:50 am

    #1558452

    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.

  • November 13, 2012 at 7:41 am

    #1558497

    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.

  • November 13, 2012 at 7:47 am

    #1558502

    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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply