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?
 
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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
All Courses

From novice to tech pro — start learning today.