SQL Backup 5   

Log Shipping: Specify Source and Destination Database

See Also
Log Shipping > Specify Databases > Backup Settings > Restore Settings > Network Share > Schedule > Review Summary

This topic describes the Log Shipping wizard page for selecting the SQL Server instance and database that you want to back up (the source database), and the SQL Server instance and database to which you want to restore the transaction logs (the destination database).

In Step 4 of the wizard, you will specify the network share to which backup files will be copied. The user that the SQL Backup Service is running as on the source SQL Server must have permissions to create files on the network share you are going to use.

Similarly, the user that the SQL Backup Service is running as on the specified destination SQL Server must have permissions to access the network share and to erase files from the network share, so that it can move the files.

Source database

In the SQL Server list, click the name of the SQL Server instance for the database for which you want to ship transaction logs.

You can select a remote SQL Server instance only if SQL Backup Pro is installed on the SQL Server instance.

In the Database list, click the database for which you want to ship transaction logs. SQL Backup lists the databases on the selected SQL Server that use the FULL or BULK-LOGGED recovery model.

Destination database

Select the SQL Server on which you want to restore the transaction log backups.

You can then choose to restore the transaction logs to an existing database on the destination SQL Server, or to a new database.

To restore the transaction logs to an existing database on the destination SQL Server, select Overwrite existing database, and then select the name of the database.

To restore the transaction logs to a new database, select Create a new database to restore to. Then type a name for the new database and specify the folders in which you want the database's data and log files to be stored.

 

 

 


© Red Gate Software Ltd 2007. All Rights Reserved.