Select Server & Database
This topic describes the Transaction 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 Network Share of the wizard, you will specify the network share to which backup files will be copied. The user that the SQL Backup Manager 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 Manager 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.
In the Database list, click the database for which you want to ship transaction logs. SQL Backup Manager 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.
|