Specified network name is no longer available.

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Specified network name is no longer available.

Postby cjeremy74 » Mon Aug 31, 2009 3:17 pm

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
cjeremy74
 
Posts: 9
Joined: Thu Oct 04, 2007 8:03 pm

Postby Brian Donahue » Tue Sep 01, 2009 4:57 pm

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/C ... 000212.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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests