April 26, 2010 at 8:29 am
Hi all,
Occasionally backups will fail on our sql 2005 servers with the error: 18210, severity: 16, state: 1.
Within the sql server logs it states "Backupdiskfile: requestdurablemedia: failure on backup device '\\share\folder'. Operating system error 64(The specified network name is no longer available)."
After a bit of searching it appears this happens due to a network hiccup during backup.
Is there a way to prevent this? Do you guys usually back up locally and then have some tool or code to transfer the files over somewhere else?
Thanks in advance.
April 26, 2010 at 8:36 am
The best way to resolve this issue is to backup to a local disk then copy to your network resource. The network copy is more resilient to network issues where as the SQL Backup is much less tolerant of network issues.
April 26, 2010 at 8:46 am
Thanks Lynn. Anyway to automate this or do you do it manually? We have many servers and databases.
April 26, 2010 at 8:48 am
Yes, it can be automated. One way is to add an additional job step that handles the network copy.
April 26, 2010 at 9:00 am
chrisph (4/26/2010)
Thanks Lynn. Anyway to automate this or do you do it manually? We have many servers and databases.
EXEC master..xp_CMDShell 'XCOPY d:\srvr1\MSSQL.1\MSSQL\Backup \\fs01\Backup\DBA02\srvr1\FINAL2\FULL /d/c/v/y'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 26, 2010 at 9:07 am
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply