Online Documentation for SQL Backup for SQL Server

Specifying database pairs


At this step you need to set database pairs for database shipping.

 

Service tasks - Database Shipping - Specifying 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 backup files are shipped to from the drop-down list.

 

Set the database pairs in the grid. The full database backups are performed on the source server and restored on the destination server.

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. Creating the databases is performed by creating a full backup of the source database and its further restoring.

 

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.