Re: Backup to a network share
- From: "Ulf Kirsten" <UlfKirsten@xxxxxxxxxxxxxx>
- Date: Tue, 24 Aug 2010 20:10:58 +0200
Thank you for your answer. I will try to run sqlserver service under a domain account, since the data is very confidential (no admin has access, only the managing director...). So to give the computer account access is not the way...
UK, Dresden, Germany
"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag news:47D14935-F4F7-4358-9DB0-9C8E370EB5BB@xxxxxxxxxxxxxxxx
.What have I to do, that the backup runs not unter the account of the computer, but of mydomain\me? The SQL Server service runs as NT Authority\networkservice, the SQL Server agent (which shall make the backups at the end of the day) runs under a domain user account.
AFAIK, the SQL Server service account must have permissions to the share for BACKUP/RESTORE. The Best Practice is to run SQL Server services under a domain account with minimal permissions, including the needed permissions to the share. Alternatively, you can backup locally and then copy the backup file remotely via a second SQL Server Agent job step that runs under a proxy account that has share permissions.
Hope this helps.
SQL Server MVP