Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
What are SqlBackupAndFTP command-line options? Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Saturday, August 15, 2009 10:27:37 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 253
What are SqlBackupAndFTP command-line options?
Back to top
  |
ruslan
#2 Posted : Saturday, August 15, 2009 10:29:07 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 141
Here are command line options for SQLBackupAndFTP:
* To run a job (immediately or scheduled) use SqlBackupAndFtp.exe -r <filename.jobx> [{-diff | -log | -fullcopy | -logcopy}]
Examples:
Full backup: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx"
Differential backup: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -diff
Transaction log backup: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -log
Copy-only log backups: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -logcopy
Copy-only full backups: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -fullcopy

* To open a job for editing use SqlBackupAndFtp.exe <filename.jobx>
* To schedule a job use SqlBackupAndFtp.exe -s <filename.jobx> [<username> <password>]

The Setup program also can accept command line parameters. You can find the details here:
http://unattended.source...Switches_ExitCodes.html

See this post on how to schedule multiple backups per day:
http://www.sqlbackupandftp.com/forum/yaf_postst28_Multiple-backups.aspx
Back to top
 Report Abusive | Report SPAM | Edit by moderator: Thursday, April 22, 2010 5:35 AM | Reason: Not specified
Guest
#3 Posted : Wednesday, May 12, 2010 4:18:44 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 253
OK I have looked at the KB article. What I am unsure about is how I can apply this to my current jobs created and scheduled through the gui. Is there a way to add options to jobs that are already configured.

I need to backup transaction logs. Does the -log option do a full as well as a transaction log backup or do I have to do a full and a transaction log backup?
Back to top
  |
ruslan
#4 Posted : Wednesday, May 19, 2010 2:40:01 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 141
Guest wrote:
OK I have looked at the KB article. What I am unsure about is how I can apply this to my current jobs created and scheduled through the gui. Is there a way to add options to jobs that are already configured.
I need to backup transaction logs. Does the -log option do a full as well as a transaction log backup or do I have to do a full and a transaction log backup?


Consider command-line options to be modifiers of a job. Job file (*.jobx) only makes full backup. If you add -log options, it will do transaction log backup instead of full.
Back to top
 Report Abusive | Report SPAM
ruslan
#5 Posted : Wednesday, May 19, 2010 3:00:42 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 141
Let's review an example: let's say you want to make a full backup on Saturday at 3pm and differential backups every other day.
1. You start by creating a full backup job in GUI and schedule to run it at 3pm every day. Let's say you've saved this job as C:\new.jobx.
2. In windows schedule you open the scheduled task for this job named like SQLBackupAndFtp_new (in the Run field you see something like "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx") and modify it to run on Saturdays only - you full backups are set. I would also rename the scheduled task to something like SQLBackupAndFtp_full
3. In windows schedule you create a new task to run every day except Saturday and in the run command you specify the same command plus "-diff" option like this: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -diff
You are done
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 cannot create polls in this forum.
You can vote in polls in this forum.