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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
Kyle AbrahamsSenior .Net DeveloperCommented:
could be the device failing itself.  Any jobs to power cycle the device or anything?  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Harmon-ITAuthor Commented:
Power Cycling the NAS after each backup has resolved the issue. Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.