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 |
|
tstrub
Starting Member
4 Posts |
 Posted - 2013-11-05 : 11:46:45
|
| Hello, I am attempting to set up a job on SQL 2012 that will do a nightly backup as a first step and then move the backup to another server as the second. I am finding that since the backup is done under the permissions of the builtin sqlagent account, it is unable to then have the proper permissions to move the .bak file to the other network server. I know that proxies can help in this, but am a bit unclear on the way that I need to get them set up. Would appreciate any insight! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-05 : 12:18:18
|
| Why not just grant the sqlagent account permissions to the network share?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tstrub
Starting Member
4 Posts |
Posted - 2013-11-05 : 12:49:45
|
| Hi thanks for the reply. This is the NT Service account that is machine-specific, so while I can do anything on the local machine, it has no domain rights. So while the backup part to the local machine running it under the agent does great, when I attempt to have it run a Powershell script to move the file, it fails. I understand that I should be able to "proxy" that account by way of an AD account, but haven't been able to figure the steps needed for that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-05 : 13:11:26
|
| But it can have rights to network resources. Just add the computer account to the network share. Like this: ServerName$Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Backup/Move Job