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 |
|
dba123
Yak Posting Veteran
90 Posts |
 Posted - 2008-01-22 : 15:49:59
|
| I get this message when trying to create my backup from Management Studio with T-SQL. I already made sure my local windows account (on my Vista Ultimate PC) has full access to all folders on my C Drive. I even gave everyone all access to the C:\SQLBackups folder. Yet when I run the script below, I still get access errors:BACKUP DATABASE MyDBNameTO DISK = 'C:\SQLBackups' WITH FORMAT, NAME = 'MyDBName'GOMsg 3201, Level 16, State 1, Line 1Cannot open backup device 'C:\SQLBackups'. Operating system error 5(Access is denied.).Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally."MyDBName" is just an arbitrary name for this post. The database is simply a local database on my home PC running Vista Ultimate. |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-01-22 : 15:54:10
|
| is that path on the server or the workstation running Mgmt Studio. Or are they the same machine?Also, make sure the service account that SQL is using has access to whatever folder (if its network share, etc)Nathan Skerl |
 |
|
|
dba123
Yak Posting Veteran
90 Posts |
Posted - 2008-01-22 : 16:05:53
|
| Local Database on my home PC running Vista Ultimate. |
|
|
|
dba123
Yak Posting Veteran
90 Posts |
Posted - 2008-01-22 : 16:24:11
|
| ss |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-01-22 : 16:38:17
|
| Sorry, I do not have Vista so i could not comment on permission issues. I would try running the SQL Server service under your local windows account and try the backup again. At least youll be able to verify its a permissions issue. And make sure the folder is not read-only.Nathan Skerl |
|
|
|
|
|
|
Cannot open backup device 'C:\SQLBackups'. Operati