Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Pushing backups to Rackspace Cloud Files Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Monday, September 05, 2011 11:42:41 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Can I easily use SqlBackupAndFTP on Rackspace, to push backups to their Cloud Files? I can write / create scripts myself to connect to their service and push the files - just need some sort of "trigger" or "user exit" that passes me the file name once the backup is generated, so I can transmit it.

In other words "SQLBackupAndRunUserScript" :-)

Ideally I would only want to generate the confirmation email message once the upload is complete.
Back to top
  |
ruslan
#2 Posted : Tuesday, September 06, 2011 10:18:11 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
In advanced settings go to "Customize backup file name" and select something simple.
Create a .bat file.
In the first line have a call to SBF like:
"C:\Program Files\Pranas.NET\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx"
In the following lines write you script that transfers the created file

The emails (success/failure) will unfortunately be sent prior to your upload script.
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.