Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup system error 5 Expand / Collapse
Author
Message
Posted Tuesday, September 2, 2014 12:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 14, 2014 5:25 PM
Points: 18, Visits: 48
When performing a backup I'm reciving the error message:

"System.Data.SqlClient.SqlError: Cannot open backup device. Operating system error 5(error not found). (Microsoft.SqlServre.Smo)

This is backing up to a network location and I'm able to backup other database on the same server/instance without error so it shouldnt be a permissions issue?

Any ideas why I can backup some databases to this location and not others?
Post #1609445
Posted Tuesday, September 2, 2014 12:41 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 3,068, Visits: 3,291
Do you (or the account running the backup) have access to the particular location?

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1609446
Posted Tuesday, September 2, 2014 12:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:19 AM
Points: 2,112, Visits: 5,477
The fact that you have other backups to the same network drive, doesn't mean that this cannot be a permission problem. For example in many places you can't backup to the drive's root, but you can backup to any directory on the drive. Another case can be that you have permissions to backup the database to a specific directory on the server, and this time you tried to backup the database to a different one.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1609449
Posted Tuesday, September 2, 2014 1:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 14, 2014 5:25 PM
Points: 18, Visits: 48
The account I'm running the job under and I'm logged in as both have full permissions to the backup location.
Post #1609454
Posted Tuesday, September 2, 2014 1:40 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 449, Visits: 1,427
Run this:

exec xp_cmdshell 'dir \\your_server\your_share\ /S'
Post #1609776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse