SQL Backup Issue

I have a backup job that runs everynight through SQL server 2005 to a NAS device.  The job fails every other night.  When it fails I get the error that says the network name cannot be found.  Also I can run the job manually at any time and it runs just fine.

Thank you,
Harmon-ITAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kyle AbrahamsConnect With a Mentor Senior .Net DeveloperCommented:
could be the device failing itself.  Any jobs to power cycle the device or anything?  
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
are you hitting the NAS by UNC or by mapped drive?

Anything in the event viewer around the time the job is failing?
0
 
RiteshShahCommented:
I guess you network is the culprit
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Harmon-ITAuthor Commented:
I am going to the NAS by UNC.  In my event viewer I have this error message:
18210 :
BackupMedium::ReportIoError: write failure on backup device '\\172.17.8.98\Share\SQL Backups\Critical\BAANDB2.bak'. Operating system error 64(The specified network name is no longer available.).
0
 
RiteshShahCommented:
error message proves my doubts, your network loosing the connection with your NAS I guess.
0
 
chapmandewCommented:
can you connect via folder name directly?

\\172.17.8.98\c$\SQL Backups\Critical\BAANDB2.bak'
0
 
Harmon-ITAuthor Commented:
Yes I can connect directly to that file, The job also runs fine every other day.
0
 
Harmon-ITAuthor Commented:
Power Cycling the NAS after each backup has resolved the issue. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.