Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
How to set differential backups? Options · View
ruslan
#1 Posted : Wednesday, December 09, 2009 2:24:29 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 350
How to set differential backups?
ruslan
#2 Posted : Wednesday, December 09, 2009 2:32:23 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 350
UPDATE: starting v6 you can use an interface for it - just click on Advanced Schedule
There's no interface for setting differential backups (it is coming in v 6) - only command line options. In a common scenario let's say you want to setup your full backup to run on Sunday, and differential - every other day. In this case you need to:
1. Create a job with all the settings you need and save it let's say like C:\new.jobx. Don't schedule it in the interface.
2. In Windows Scheduler for Sunday create a task like "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" to do a full backup
3. In Windows Scheduler for Mon-Sat create a task like "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -diff to do differential backups

Do you need to do transaction log backup? Use "-log" option instead of "-diff"
Do you need to do backup multiple times a day - go ahead do whatever you want in scheduler. Zip files won't be overwritten because they have time in the filename.

Command-line options are in this post: http://www.sqlbackupandftp.com/forum/yaf_postst25_What-are-SqlBackupAndFTP-commandline-options.aspx
demo@example.com
#3 Posted : Thursday, May 12, 2011 9:31:09 PM Quote
Rank: Newbie

Groups: Registered

Joined: 4/5/2011
Posts: 2
I'm loving this software as it's a consultant's dream all the esential features in an easy GUI.

Can you tell me if the -log param will also truncate the transaction log to keep size down?

Thanks,
Santiago
ruslan
#4 Posted : Friday, May 13, 2011 4:26:34 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 350
When SQL Server finishes backing up the transaction log, it automatically truncates the inactive portion of the transaction log
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.