Online Documentation for SQL Administrator for SQL Server

Selecting server and setting restore type


This step of the wizard allows you to specify the server to restore database, and choose restore type.

 

Restore Database Wizard - Selecting server and setting restore type

 

 

Server group

Use the drop-down list to select a server group where the server is stored.

 

Server name

Use the drop-down list to select the host/instance name to restore database to.

 

Select restore type

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

 

!RadioButton Restore entire database

Full restore of entire database.

 

!RadioButton Restore files or filegroups

Differential restore of 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 Restore 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 only (without restoring)

Select this option to execute the database recovery only.

 

!RadioButton Restore from database snapshot

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

 

Click the Next button to proceed to the Setting database step of the wizard.