x
login about faq Site discussion (meta-askssc)

BACKUP DATABASE manish TO DISK = 'E:\filename.BAK'

whats wrong with this? I m getting an error like...

Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'E:filename.BAK'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.

more ▼

asked Feb 20 '11 at 02:54 PM in Default

krishna 2 gravatar image

krishna 2
13 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Sounds like a permissions error. Are you trying to run a backup to your local drive from a system database? You can't do that unless you use a UNC path, which I wouldn't recommend. Better to backup to a local drive on the server and then copy the file across. Or, it's possible that the account the server is running under doesn't have access to this drive if it's on your server.

more ▼

answered Feb 20 '11 at 03:14 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
62.4k 12 20 66

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x2

asked: Feb 20 '11 at 02:54 PM

Seen: 302 times

Last Updated: Feb 20 '11 at 02:54 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.