MSDB database not responding

  • 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

  • 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.

  • 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.

  • 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