August 22, 2002 at 7:49 am
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
August 22, 2002 at 7:50 am
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
August 22, 2002 at 7:55 am
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
August 22, 2002 at 8:00 am
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
August 22, 2002 at 8:10 am
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
August 22, 2002 at 2:00 pm
Which logs should I be looking at?
Thanks,
Neil
August 22, 2002 at 2:06 pm
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
August 22, 2002 at 2:44 pm
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
August 22, 2002 at 2:55 pm
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