Online Documentation for SQL Backup for SQL Server
Specifying database pairs
At this step you need to set database pairs for database shipping.
Select the server where the database that you want to back up to another server is located.
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.
Specify the path for data MDF files for the newly created database.
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.