Job Failed::back up job failed due to network path.

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

manishankar_83 Old Hand Points: 391 More actions · Answer 1

Hi,

Open the backup job and see if the backup folder is on your loacal machine or onto some network shared folder.

If its on the network then see if you can access that file from the node which is hosting SQL server

Thanks,

Mani

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 2

Once you find it , stop taking backups on network .

you will endup loosing it many times .many a times if you verify the backups you will find them corrupt .

I burnt my Fingers 4 years back .

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

ps. One Orange Chip Points: 29422 More actions · Answer 3

Also, speak to your network guys on the network fluctuations.

Run this command and give it to the network guys as proof of fluctuation.

c:\> ping xx.xx.xx.xx -t > c:\ping_results.txt

This will create a ping result in a text file. If u're having fluctuations, those will be captured in the text file.

Pradeep Singh

Chand00 SSCertifiable Points: 6466 More actions · Answer 4

Always take the backup to local disk on the server and transfer it over the network to the destiation after the backup is successful.

Thanks

Chandra Mohan N

[font="Verdana"]Thanks
Chandra Mohan[/font]

SQListic SSCertifiable Points: 6904 More actions · Answer 5

Try this

EXEC xp_cmdshell 'net use v: \\ServerName\foldername'

Here we are assigning V as drive letter to the path \\ServerName\foldername'