Can't Backup MSDB!!!

  • I get an error trying to backup the MSDB

    BACKUP DATABASE is terminating abnormally.

    Any ideas why this would be a problem? I am concerned because we just did post sp2 hotfixes.

    Neil

  • Any error messages associated with the abnormal termination?

    -------------------------

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • I believe so. I am backing them up again to give it a shot. I will let you know if I see that error.

    Neil

  • I am doing a manual backup and I get the dialog box so I only see the one original error and that is it.

    Thanks....

    Neil

  • Does the errorlog file in the log directory contain any information to help you determine why you might be abnormally terminating.

    -------------------------

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • Which logs should I be looking at?

    Thanks,

    Neil

  • If you haven't change the standard installation for logs, it would be the errorlog file in the log directory under the mssql directory. Also you can look in the current log (or for that matter any old log) using EM. To to this in EM, expand the managment folder, then the SQL Server logs foler, and then click on one of the logs. If you have not rolled your SQL box, the error, if one was produced would be in the current log.

    Hope this helps. If not let me know.

    -------------------------

    Greg Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • I keep getting:

    BackupDiskFile::RequestDurableMedia: failure on backup device '\\Neil\D$\SQL\Neil\msdb\msdb_db_200208212022.BAK'. Operating system error 64(The specified network name is no longer available.).

    This is a new backup server so it concerns me that there would be a network issue. I Have other servers backing up to this machine so its very strange. Is there a time out setting I could be missing?

    Thanks,

    Neil

  • Does your box where you where performing the restore have access to that network share? Does that backup on the network share exist?

    If so, one option might be to copy the backup to a local drive on the machine you are trying to do the restore, and then point the restore to the backup you copied to the local drive.

    Hope this helps.

    -------------------------

    Greg Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

Viewing 9 posts - 1 through 8 (of 8 total)

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