Link to home
Start Free TrialLog in
Avatar of marvo2010
marvo2010

asked on

Network parth was not found

Hello,

My database backs up to a path described in stored procedure but suddenly the back up procdure starts spitting out the error :

 Cannot open backup device  (file path) Operating system error 53(The network path was not found.).

The file path is very correct .

Pls can some one tell me how to make this work.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of dwkor
dwkor
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
Avatar of marvo2010
marvo2010

ASKER

@ dwkor:

Yes it does. I have also physically logged into the server where the back up dist is and it all went through. I ahve pinged the server from the sql server machine back and forth and all round and it all went well.

I dont know what might be throwing the error. This is a back up operation that has been be happening for ages.

Any more thoughts?

Thanks
Can you check what is the SQL Server and SQL Agent startup accounts? How is backup SP calling?

Can you call this SP manually from management studio when you connect to the server using windows authentication (assuming you have enough rights).
@dwkor:

I ahve called the Stored Procedure manually and it throws the same error :

Cannot open backup device  (file path) Operating system error 53(The network path was not found.).

I am the DBA and I have adequate rights . The server where the back up dist shut down unplanned the day the error started. I am thinking this error might be linked to that unplanned shut down

Avatar of Anthony Perkins
Please post your stored procedure and indicate how you are executing it.  This last will help you identify the account used to execute the Stored Procedure: SQL Server or SQL Server Agent service startup account.
The path of the backup was changed by some one in my team with out my knowledge , so the path in the stored procedure was no more the physical path to the backup device.so effectively the right to the path was changed. I never detected this till much later and then I adjusted the stored procedure and the back up started working again.