Specified network name is no longer available.

[cjeremy74]

We are backing up directly to a network location and have starting seeing a swarm of errors (see below). I do not see a pattern regarding time or database involved. Our network engineer is showing no network interruptions (although I am asking for some additional research from his side as well). This is causing our db and log backups to be corrupt. Any thoughts - did not see anything in forum on initial search.

------------------------------------------------
Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file:
\\nas1\SQLBackupFolder\....sqb
Warining: System error 64 (The specified network name is no longer available)

Thread 0 error:
Error 620: Error writing to backup file(s).

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

Thanks - J.
_________________
Thanks - JC

[Brian Donahue]

Hello JC,

I'm sorry you haven't found error 64 in the forums as it is quite common and the reason why the network resilience feature had been implemented in SQL Backup 6. Windows Networking implements some heavy, unreliable protocols and any copy operations are subject to the whims of network conditions.

Aside from upgrading, you can try increasing your session timeout.
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=knowledgebase%5cSQL_Backup%5cKB200801000212.htm

I also suspect, although never proven, that enabling NETBIOS over TCP on your network connection properties helps. I think this gets the connections using DNS instead of that ancient browser service that Windows peer-to-peer networking uses.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521