Page History
...
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.
By default, SQLsafe SQL Safe initializes the database with a newly-generated full backup.
| Info |
|---|
SQLsafe SQL Safe detects when the primary database was previously configured to use the simple recovery model and requires for a new full backup to be performed to initialize the secondary database for the new log shipping policy. Full backups of a database using the simple recovery model lack log checkpoint information necessary for subsequent log restores. |
...
- Do not initialize. Database exists and has received most recent backup of primary database.
- Initialize database with a newly generated full backup. This will be the only option available when SQLsafe SQL Safe detects that the primary database was previously configured to use the simple recovery model and requires for a new full backup to initialize the secondary database.
- Initialize database with these backups. If you enable this option, you can specify the location of the backups and add encryption settings.
...
| Note |
|---|
Take into account that to restore from a different location, the database must already be initialized. |
SQL
...
Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...