Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 27, 2016 12:20 AM
Points: 25, Visits: 80
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 AM
Points: 4,044, Visits: 4,214
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: Wednesday, May 25, 2016 1:42 AM
Points: 2,164, Visits: 5,858
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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 27, 2016 12:20 AM
Points: 25, Visits: 80
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 7:43 AM
Points: 601, Visits: 2,313
Run this:

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

Add to briefcase

Permissions Expand / Collapse