Post reply

Could not insert backup or restore history/detail in msdb

  • October 22, 2004 at 2:38 pm

    #109607

    I get the following message on some (not all) of my backup jobs following a full disaster recovery

    Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful. [SQLSTATE 42000] (Error 3009)  SqlDumpExceptionHandler: Proc...  The step failed.

    Is this a problem and how can I cure it?

    1) Installed fresh NT and SP6 applied

    2) Installed SQL2000 and installed SP3a

    3) Restored all System databases from backup.

    4) Attached User databases (as they were on another drive)

    5) Full database backup taken after system fully operational

    Any help appreciated. Regards

  • October 22, 2004 at 5:01 pm

    #527729

    This maybe a bug in sql, try this:         http://support.microsoft.com/default.aspx?scid=kb;EN-US;319701.

    restore msdb from QA not from EM.

     

      Good luch. Thanks!

  • October 25, 2004 at 7:33 am

    #527793

    Tried using QA but still failed (in a sense) with this message

    Processed 19064 pages for database 'msdb', file 'MSDBData' on file 3.

    Processed 1 pages for database 'msdb', file 'MSDBLog' on file 3.

    Server: Msg 3009, Level 16, State 3, Line 1

    Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.

    ODBC: Msg 0, Level 19, State 1

    SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    RESTORE DATABASE successfully processed 19065 pages in 16.812 seconds (9.289 MB/sec).

    Desparately seeking help

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

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