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 | 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:
Specify folders and recovery options
See also: |