Link to home
Start Free TrialLog in
Avatar of Harmon-IT
Harmon-IT

asked on

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,
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

are you hitting the NAS by UNC or by mapped drive?

Anything in the event viewer around the time the job is failing?
I guess you network is the culprit
Avatar of Harmon-IT
Harmon-IT

ASKER

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.).
error message proves my doubts, your network loosing the connection with your NAS I guess.
can you connect via folder name directly?

\\172.17.8.98\c$\SQL Backups\Critical\BAANDB2.bak'
Yes I can connect directly to that file, The job also runs fine every other day.
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Power Cycling the NAS after each backup has resolved the issue. Thanks!