question

krishna 2 avatar image
krishna 2 asked

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.
sql-backup
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.