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 |
|
evanburen
Posting Yak Master
167 Posts |
 Posted - 2010-01-29 : 16:07:49
|
| I'm using SQL Server Express 2008 and having difficulty backing up a database. I keep receiving a operating system level message that access is denied to the folder I'm trying to back up the database to. Using Management studio remotely, I'm using the sa account and receive this message. On the server itself (which does not have SQL Management Studio installed on it), I'm trying to use SQLCMD. With SQLCMD, if I try and run the BACKUP DATABASE command using my Windows login which is in the local Adminstrator's group I still receive this error message. SQLCMD -U myusername -P mypassword BACKUP DATABASE IMF_ED TO DISK = 'd:\DCS\SQL2008\backups\IMF_ED.bak'So I guess my question is: how do I give the sa account access to this folder on the server or how do I backup this backup using my Windows admin login to backp this dabase?Thanks |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-01-29 : 22:47:50
|
| What account is the sql service running under? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-30 : 09:24:26
|
| backup runs under context of service account.make sure service account has permission to d:\DCS\SQL2008\backups\ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-30 : 10:30:12
|
| As well as what has been suggested , i.e ensure the sql service account has the right permissions , what is the owner of the db that you are trying to backup?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
evanburen
Posting Yak Master
167 Posts |
Posted - 2010-02-01 : 07:17:16
|
| The service is running under the Network Service account which has read access to the backups folder but not write access. Is it safe to give this account write permissions to this folder? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-02-01 : 09:08:16
|
| I would recommend you have a dedicated sql service account, this shouldn't be a typical user account , as it may allow to much access to a server Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
Using SQLCMD for backups