Add or Edit Destination Database
Use the Add or Edit Destination Database screen to enter information about the destination database for log shipping.
Options
Server name
Choose the destination server for log shipping.
Directory
Choose the directory on the destination server where you want the transaction logs to be shipped. Click the browse (...) button to search for the appropriate disk directory.
Create and Initialize New Database
Create a new database on the destination server for use with log shipping.
Database Name
Specify the name of the database you want to create.
For Data
Specify the directory on the destination server that you want to use for the new database files. Click the browse (...) button to search for the appropriate disk directory.
For Log
Specify the directory on the destination server where log files for the new database are to be stored. Click the browse (...) button to search for the appropriate disk directory.
Use Existing Database (No initialization)
Use an existing database on the destination server for log shipping.
Database Name
Choose the database to be used for log shipping.
No Recovery Mode
Leave the destination database in No Recovery mode. User access is not possible with databases in No Recovery mode.
Standby Mode
Leave the destination database in Standby mode.
Terminate users in database (Recommended)
Specify if the connections users have to the destination database should be automatically terminated.
Allow database to assume primary role
Specify if the destination server should be setup to be able to function as a primary server.
Directory
Specify the directory on the destination server where the database transaction logs are to be stored when the secondary server is functioning as the primary server.