Online Documentation for SQL Backup for SQL Server

Specifying database pairs


At this step you need to set database pair for transaction log shipping.

 

Transaction Log_Specify database pairs

 

 

Source server

Select the server where the database that you want to back up to another server is located.

 

Destination server

Select the server where transaction logs are shipped to from the drop-down list.

 

Set the database pairs in the grid. The backups of transaction logs are performed on the source server and restored on the destination server. The destination database must be the restored copy of the source database and be in Restoring state.

If the destination database does not exist, you can select <Create new> item in the Destination DB column and specify its name in the New database column. If the destination database needs rewriting, set the corresponding flag in the Overwrite column. Creating and overwriting of the databases is performed by creating a full backup of the source database and its further restoring. Even in case of scheduled execution, creating of a database is executed once immediately on wizard finish and the <Create new> item will be replaced with the created database name afterwards.

 

Data folder

Specify the path for data MDF files for the newly created database.

 

Log folder

Specify the path for data LDF files for the newly created database.

 

Note: When creating a template no databases can be selected at this step. Please proceed to the next steps to set default template options. Databases can be selected on applying the template to the policy.