Sean Carpenter

Thoughts on Development

  Home  |   Contact  |   Syndication    |   Login
  15 Posts | 1 Stories | 1 Comments | 7 Trackbacks

News



Twitter












Archives

Post Categories

About

We back up our SQL Server databases to a central storage machine using UNC paths in the BACKUP statement (BACKUP DATABASE db1 TO DISK='\\storage\Backups\db1\db1.bak...). For a while, backups were failing with the message:
BackupDiskFile::RequestDurableMedia:  failure on backup device '\\storage\Backups\db1\db1.bak'. Operating system error 64(The specified network name is no longer available.).

I struggled for a while to find a solution and finally found this thread on www.msce.ms.  Unfortunately that seems to have disappeared, so this is a summary of what that thread recommended (and what worked for me):

  • Open the registry of the SQL Server machine and navigate to HKLM\System\CurrentControlSet\Services\lanmanworkstation\parameters
  • Create a new DWORD value named SessTimeout (if it's already there I guess you can change the value but it wasn't there on any server I was having the problem with).
  • Set the value to decimal 600 (hex 0x258) - I believe this is seconds.

This corrected the problem for me (on two machines I had to bump the value to 900) and seems to have no ill effects on the rest of the server.

posted on Wednesday, February 15, 2006 6:54 AM

Feedback

# re: SQL Server Backup to UNC Path Failing 3/15/2006 2:38 PM Tory
What version of Windows did you try this on?

I am having a problem with windows 2003 and 2000 Server.

# re: SQL Server Backup to UNC Path Failing 3/16/2006 12:55 PM Sean
I have had success with this on a single Windows 2000 server and several Windows 2003 machines.

# re: SQL Server Backup to UNC Path Failing 3/5/2007 2:19 PM Chris
Make sure the SQL is running under the domain account.

Chris

# re: SQL Server Backup to UNC Path Failing 3/5/2007 2:21 PM Chris Bowie
Also, if your SQL machine bootup without a domain account, using UNC will give you that error.



Comments have been closed on this topic.