SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup/Move Job
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tstrub
Starting Member

4 Posts

Posted - 11/05/2013 :  11:46:45  Show Profile  Reply with Quote
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

USA
37161 Posts

Posted - 11/05/2013 :  12:18:18  Show Profile  Visit tkizer's Homepage  Reply with Quote
Why not just grant the sqlagent account permissions to the network share?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tstrub
Starting Member

4 Posts

Posted - 11/05/2013 :  12:49:45  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37161 Posts

Posted - 11/05/2013 :  13:11:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
But it can have rights to network resources. Just add the computer account to the network share. Like this: ServerName$

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000