Edit Destination Database (Thresholds Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Edit Destination Database (Thresholds Tab)

Use this tab to view or specify the following options.

Options

Out of sync threshold

Specify the maximum elapsed time between the last transaction log backup on the source server and the last transaction log restore on the destination server.

Load time delay

Set the amount of time you want the destination server to delay before it restores the transaction log from the source server. The default for this option is zero minutes, indicating that the destination server should immediately restore any transaction log backups. Changing the time delay would provide a cushion of time if something goes wrong on the source server, allowing you to correct the problem before the corrupted log is restored onto the destination server.

File retention period

Specify how long to wait before a transaction log is deleted.

History retention period

Specify how long to wait before a transaction log history is deleted from the log_shipping_plan_history table.

See Also

Log Shipping