SQL Backup 10

Log shipping - set the schedule

Log shipping > Specify databases > Backup settings > Network share > Restore settings > Schedule > Review summary

On step 5 of the wizard, specify the schedule for backing up the transaction logs, and for restoring the backups.

The schedule defines the time and frequency of the backups. For example, you may want to make transaction log backups every 5 minutes.

A default schedule is displayed for the backups. To change the schedule, click Edit, and on the Schedule Editor, specify the schedule and click OK.

You are recommended to use the backup schedule as a basis for the restore schedule. Select Base on transaction log backup schedule and in Offset, type or select the number of minutes by which you want to delay the restore operation after the backup has started. The offset time should be long enough to allow the backup to complete.

Alternatively, you can set up a separate schedule for the restore operations. Select Specify a schedule. To change the default schedule, click Edit and on the Schedule Editor, specify the schedule and click OK.

Next: review summary


Didn't find what you were looking for?