September 2, 2014 at 12:37 am
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?
September 2, 2014 at 12:41 am
Do you (or the account running the backup) have access to the particular location?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]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
September 2, 2014 at 12:44 am
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/
September 2, 2014 at 1:00 am
The account I'm running the job under and I'm logged in as both have full permissions to the backup location.
September 2, 2014 at 1:40 pm
Run this:
exec xp_cmdshell 'dir \\your_server\your_share\ /S'
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply