May 12, 2015 at 7:34 am
I have a job (SQL Agent) attempting to copy database backup files to a network share. I have used mapped drives and they seem to work for a while and then get the "The specified network name is no longer available." error. To troubleshoot, I've used both of these statements in SSMS and still get the same error:
EXEC xp_cmdshell 'dir W:\ '
EXEC xp_cmdshell 'dir \\programmer1\A-offsitebackups '.
It seems to work for a while, then something happens and I'll get the error. If I restart SQL Server, it will probably start working again (I think- I've tried so many things I can't keep up). The database server has mapped drives to these same locations and I can see the contents of the folders from Windows Explorer. Also, part of the job employs a scheduled task on the server to copy the logs and the DB file to a network share. The log copies with no problem, but the DB file (15GB) fails. So, I don't get it. Anybody know why this happens?
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply