What is the error of my sql query?

Question

0.00/5 (No votes)

See more:

Hello,

BACKUP DATABASE ankit TO DISK = 'C:\Ankit_Full.bak'

I am writing this query for database backup but it's not running.

this query getting error:-
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:\Ankit_Full.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

How can we solve?
I have checked all service, everything is ok.

Please help me.

Thanks
Ankit Agarwal
Software Engineer

Posted 8-Nov-13 1:05am

ankit.agg1984

Add a Solution

2 solutions

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)

E.F. Nijboer · Answer 1 · 2013-11-08T01:15:00

Solution 1

For some time now it isn't allowed to write directly to the root of the primary drive used to boot windows. Simply put it into a subdirectory.

Good luck!

Posted 8-Nov-13 1:15am

E.F. Nijboer

Comments

thatraja 8-Nov-13 7:20am

Right & even if it allows to save in root path, that's not suggestable. 5!

CHill60 8-Nov-13 7:59am

And my virtual 5 for this very valid comment!

thatraja 8-Nov-13 8:08am

My real thanks

Rajat-Indiandotnet · Answer 2 · 2013-11-10T01:20:00

Solution 2

Hi ,

Please refer below link

http://blog.sqlauthority.com/2011/04/13/sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-5access-is-denied/[^]

Posted 10-Nov-13 1:20am

Rajat-Indiandotnet

Comments

CHill60 10-Nov-13 7:29am

Potentially useful link, but off topic as the OP was trying to write the backup file to the root of the C: drive, which is not a good idea even if the process does have the necessary access rights