SQL Backup 6

Log shipping - review summary

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

On step 6 of the wizard, review your log shipping settings.

The Summary displays the settings you have specified. When you have checked the settings, click Finish to create the SQL Server Agent jobs to perform the log shipping.

The Log Shipping wizard automatically sets up job steps using the RAISERROR command so that the SQL Server Agent reports an error if the SQL Backup command fails. For information about SQL Server Agent jobs, steps, and the RAISERROR command, refer to your SQL Server documentation.

SQL Backup displays the progress of the log shipping setup. SQL Backup performs a full backup of the source database and restores it on the secondary SQL Server.

If any tasks fail, an error message is displayed, and all subsequent operations are failed. You can optionally return to the final step of the wizard by clicking Retry in the message dialog. You can then change the settings in any of the wizard steps before running the tasks again.


Didn't find what you were looking for?