Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2010-05-13 : 19:14:48
|
| BACKUP DATABASE master TO DISK = 'e:\master_full20100513.bak'Msg 3201, Level 16, State 1, Line 1Cannot open backup device 'e:\master_full20100513.bak'. Operating system error 5(Access is denied.).Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.I get this error when I backup a database. I'm a sysadmin on the server and I can write to the E:\ drive. Anybody know a way to work around? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-05-13 : 19:42:27
|
| Yeah, my sql server account which is a windows account has access to E:\ and it has admin rights to the windows server and sql server. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-05-14 : 01:15:44
|
| I think it doesn't |
|
|
|
|
|
|
BACKUP weird error