Add Destination Database (Initialize Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Add Destination Database (Initialize Tab)

Use this tab to view or specify the following options.

Options

No recovery mode

Specify that the secondary database be made unavailable for use. The secondary database is placed in NORECOVERY mode as a result of either the RESTORE LOG operation or the RESTORE WITH NORECOVERY operation.

Standby mode

Specify that the secondary database be made available for use, but in read-only mode. The secondary database is placed in STANDBY mode as a result of either the RESTORE LOG operation or the RESTORE DATABASE WITH STANDBY operation.

Terminate users in database (Recommended)

Disconnect all users from the database. Log shipping will not work if there are any users connected to the secondary database you have configured for log shipping.

Take full database backup now

Take a full database backup now, rather than using an existing backup file.

Use most recent backup file

Specify the most recent backup file to use to initialize the destination database. Click the browse (...) button to search for a recent backup file.

Copy frequency

Set the frequency (in minutes) with which you want the destination server to back up the transaction logs from the source server.

Load frequency

Set the frequency (in minutes) with which you want the destination server to restore the transaction logs from the source server.

See Also

Log Shipping