Online Documentation for SQL Manager for SQL server

Setting restore type and recovery options


Use this step of the wizard to define a restore type and set recovery options.

 

Restore type

 

This group of options allows you to specify the restore type to be used for the restore operation.

 

RadioButton Database

Full restore or differential restore of entire database or individual files and filegroups. Files and filegroups can be restored either from a file or filegroup backup operation, or from a full database backup operation.

 

RadioButton Transaction log

Specifies that a transaction log backup will be used to restore this database. SQL Server checks the backed up transaction log to ensure that the transactions are being loaded into the correct database and in the appropriate sequence.

 

RadioButton Recovery without restore

Select this option to execute the database recovery only.

 

RadioButton Recovery from database snapshot

Select this option to restore the database from a previously saved snapshot.

 

CheckBox Restart interrupted restore

This option specifies that SQL Server should restart a restore operation that has been interrupted. The restore operation is restarted from the point it was interrupted.

 

Restore Database - Setting restore type and recovery options

 

 

Recovery options

 

This group of options allows you to specify the recovery options to be applied to the restore operation.

 

RadioButton Recovery

This option specifies that the restore operation rolls back any uncommitted transactions. After the recovery process the database is ready for use.

 

RadioButton No recovery

This option specifies that the restore operation does not roll back any uncommitted transactions.

Note: When this option is selected, the database is not usable in this intermediate, non-recovered state.

When used with a file or filegroup restore operation, this option forces the database to remain in the restoring state after the restore operation. This is useful in either of the following situations:

  • a restore script is being run and the log is always being applied;
  • a sequence of file restores is used and the database is not intended to be usable between two of the restore operations.

 

RadioButton Standby

This option allows the database to be brought up for read-only access between transaction log restores and can be used with either warm standby server situations or special recovery situations in which it is useful to inspect the database between log restores.

 

Undo file name

Specify the undo file name, so that the recovery effects can be undone. The size required for the undo file depends on the volume of undo actions resulting from uncommitted transactions. The same undo file can be used for consecutive restores of the same database.

NB: If free disk space is exhausted on the drive containing the specified undo file name, the restore operation stops.

 

 

Click the Next button to proceed to the Selecting backup set to restore step of the wizard.