Error in Backup query of sql server

Question

0.00/5 (No votes)

See more:

I have a database in SQL Server and I want to create backup from it to a shared folder.

just one of the network users has permissions to access to this folder.

I have written a code to log on this user at the middle of my program and then execute Backup command.

This code worked all ever I want to access to my folder. But now I receive this error:

"Cannot open backup device 'folder path with backup file name'.Operating system error5(failed to retrieve text for this error, Reason: 1815) BACKUP DATABASE is terminating abnormally"

Posted 14-Aug-11 19:18pm

M_Mogharrabi

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-08-14T19:29:00

The problem is that the backup is trying to access the network folder with the credentials under which SQL Server is running. In other words the backup is made by SQL Server, not by the user who executes the backup command.

You can use (create a new) domain account for SQL Server service and give proper privileges to that account if you want to take the backup directly to network. Another option is that you take it locally and then using some script transfer the backup to network share.

One example article dicussing setting the privileges for the domain account: http://support.microsoft.com/kb/283811[^]

If the thing mentioned above is already correct, check the backup settings and the target folder. For example if the backup tries to write a new file (without overwriting the old) and there's an existing file with the same name in the folder, it would fail.