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,
Thank you,
I guess you network is the culprit
ASKER
I am going to the NAS by UNC. In my event viewer I have this error message:
18210 :
BackupMedium::ReportIoErro r: write failure on backup device '\\172.17.8.98\Share\SQL Backups\Critical\BAANDB2.b ak'. Operating system error 64(The specified network name is no longer available.).
18210 :
BackupMedium::ReportIoErro
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.b ak'
\\172.17.8.98\c$\SQL Backups\Critical\BAANDB2.b
ASKER
Yes I can connect directly to that file, The job also runs fine every other day.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Power Cycling the NAS after each backup has resolved the issue. Thanks!
Anything in the event viewer around the time the job is failing?