February 14, 2008 at 9:09 am
Sql server 2005 job failure, job excute one query to insert data into a table by select from 10 more table using left join, but job is failure by give following message: "TCP Provider: The specified network name is no longer available. [SQLSTATE 08S01] (Error 64) Communication link failure [SQLSTATE 08S01] (Error 64). The step failed"
February 14, 2008 at 9:13 am
Ran into this before. It indicates that you are backing up a network share drive. If so, I recommend backing the file up locally then using a copy/move command to place the file on the network share. The problem is the network experiences a quick hickup and loses connection to the destination which in turn throws this error. According to my network associates, it's nothing that can be done to prevent such issues, however, doing the local backup and then copy/move solved the problem for me.
Marvin Dillard
Senior Consultant
Claraview Inc
February 14, 2008 at 9:25 am
Because it is throwing out pages quickly to get the backup done and maintain transactional integrity, the SQL Server backup process is extremely intolerant of network hiccups. Way, way less than a file copy.
Do not back up to remote drives. Back up locally and copy the files over.
February 14, 2008 at 9:30 am
BTW, there is a great script to do just that in script area (shameless self plug)
http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/
Marvin Dillard
Senior Consultant
Claraview Inc
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply