Versions Compared

Old Version 4

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on

compared with

New Version 5

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use this window to select the SQL Server instances you want to synchronize with the log backups from the primary database.

What options are available in this window?

SQL Server

The SQL Server that contains the database to be restored. Select a registered SQL Server or click  Register  to register a new instance.

Database

Create a new database or select the database that you want to receive the transaction log restores. To create a new database, type directly the database name in the Database field. If you want to select an existing database, click Select to access the list of databases available on the instance you have selected.

Initialization

Specifies the initial state of the secondary database that receives the transaction log restores. Click  Change to modify the type of initialization that will be performed.

...

You can also click Database File Locations in this window to choose where to store your database files. 

Database State

Select the recovery mode the secondary database is left in after each log restore.

This setting affects how the status appears for the secondary database. If you select Not Accessible (No recovery mode) , then the secondary database shows the status as "Restoring" and it is unusable. If you select  Accessible but read-only (Standby mode) , then the database is in a read-only state. In the latter option, you can choose to disconnect users when performing restore.

Restore Job

This is how often the restore will occur. Click Schedule to change the frequency. By default, the restore occurs every 15 minutes every day, but you can specify other settings for your required daily frequency and duration of the job. 

You can also choose to delay the restores by a number of minutes or hours. This represents the minimum time within which a secondary can be synced. For example, setting this value to 15 minutes would mean that the secondary will always be at least 15 minutes out of sync.

Restore From

Specify the location that will contain the transaction log backup files you want to restore (ship) to this secondary database.

...