Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Run post-job script? (to sync to backup files to offsite-location) Options · View
Previous Topic · Next Topic
skayser
#1 Posted : Monday, March 21, 2011 9:25:52 AM Quote
Rank: Newbie

Groups: Registered

Joined: 8/4/2010
Posts: 5
Hi,

is there any option within SBAF to trigger a local batch/cmd script once a job has successfully completed? We'd like to sync our backup files to an off-site CIFS share upon job completion. I've seen the FTP option which comes pretty close to what we need (the separate retention policy is great), except that our remote site doesn't offer FTP services, only CIFS and NFS.

Sebastian
Back to top
 Report Abusive | Report SPAM
ruslan
#2 Posted : Monday, March 21, 2011 10:06:36 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
Sure, to execute windows command from the SQL Server script just use xp_cmdshell.
Back to top
 Report Abusive | Report SPAM
skayser
#3 Posted : Tuesday, March 22, 2011 6:01:00 AM Quote
Rank: Newbie

Groups: Registered

Joined: 8/4/2010
Posts: 5
Cool, will give it a try. Thanks, ruslan.
Back to top
 Report Abusive | Report SPAM
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.