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.