Online Documentation for SQL Backup for SQL Server

Database Shipping


Database Shipping step allows you to create full backups on the source server, ship them to the destination server via a shared folder and restore on the destination server.

 

To perform database shipping step you must have at least two SQL Server instances; version of destination server cannot be lower than the source server version; both servers must have access to the shared folder.

 

To launch the database shipping immediately select Quick_Maintenance_Actions Quick Maintenance Actions | DatabaseShipping Database shipping popup menu item in the Servers tab.

 

To perform scheduled database shipping on a regular basis you need to include this task into Policy:

1. At Step 2 of the Create Policy wizard click Create new step button and select Database Shipping step type.

2. Also, you can create a new Step Template for further use selecting Database Shipping step at the Templates tab.

 

Steps of the Database Shipping wizard:

Naming step

Specify database pairs

Specify backup options

Specify folders and recovery options

Viewing summary information