Adding a New Target

You may want to add a new target server to an existing package in order to create another copy of the source database on a new server.

Click on the package node of the package you want to add a new target to and click on "Add Target" in the "Packages" menu.

Back Up Now or Existing Backup Files

To create every target database, the source database's backup file is needed. If one was created in the previous 24 hours, it will appear in the backup files list at the bottom. Any transaction log that was created since then, will appear in the backup files list sorted by the Backup DateTime. In case one of the backup files is missing, it will appear with an 'x' on the left column. If you could locate the missing file or files, do so and then click on the "Refresh Files List" button.

If no backup file exists or the existing file is too old, HotDBWAN will automatically select the "Back up now" option. If you'd prefer to back up the database immediately and not use the old one, select the "Back up now" option.

As default, the database backup file, used to restore the targets for the first time, is copied to the shared folder and read from there. In order to skip the backup file copy, check the "Don't copy the database backup to the shared folder" checkbox and specify the network path to the database backup file in the "Database backup network path" textbox.

Click on the "Next" button.

New Target

Choose a target server from the "Target server" drop-down combo box.
The data file, transaction log file and roll back file of the target server's new database have to be located on the target server's hard drives.

Pick each one of the files' location by clicking on the "..." button next to each location's textbox.

Target Properties

The restore interval is the number of minutes to occur between each execution of the restore job. Set the interval on the "Restore interval" up-down control.

Delay is the interval of time in minutes between the present and the point in time which the target data is updated to. Setting the delay to 30 minutes, for example, will result in the target database being an image of the source database half an hour ago. Set the delay on the "Delay" up-down control.

In order to use the target database with the same SQL security as the source, the source server logins must be copied to the target SQL server. As default, copy logins will be executed. To cancel the copy, uncheck the "Copy source server logins" checkbox.

The restore start time and the end time are the log restore job's start time and end time. Set the start time and the end time on each one's time picker control.

To assure the data update on every run of the restore job, check "Drop all target database's connections before restoring".

Note : The success of a target creation does not depend on the success of the logins copy.

Primary Role & Remote Target

You may want to allow the new target database to assume primary role. To read more about primary role, click here.

To define a target as the primary target, check the "Allow database to assume primary role" checkbox. Then, pick the database and transaction log backup locations for the primary target server to use when functioning as a source. Click on the "..." button next to each location's textbox.

Remote target is a target that pulls backup files or compressed backup files, from the shared folder into a local folder before restoring them.
To define a target that pulls backup files, check "Copy backup files from the shared folder to a local location before restoring" and set the local folder location for the backup files copied from the "shared folder".
In order to define a target that uses compressed files, "file compression" and "compressed files shared folder" have to be defined in Step 2. To enable the use of compressed files for a remote target, first check "Remote Target (use file compression)". Then, two physical locations have to be defined. One for the compressed files copied from the "compressed files shared folder" and one for the "decompressed backup files". Pick them both by clicking on the "..." button next to each location's textbox.

Click on the "OK" button. The new target creation will start immediately.