Restore Database (General Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Restore Database (General Tab)

Use this tab to view or specify the following options.

Options

Restore as database

Specify which database to restore.

Database

Restore the selected database.

Filegroups or files

Restore a filegroup or file.

From device

Restore from a device.

Show backups of database

Show backups of the selected database.

First backup to restore

Specify which backup to restore first. This option is displayed only if you restore a database.

Point in time restore

Restore a backup from a selected point in time. This option is displayed only if you restore a database. Click the browse (...) button to search for a backup.

Restore

Restore the selected backup.

Type

View the type of backup.

Backup set date

View the date of the backup set.

Size

View the size of the backup set.

Restore from

View the file location of the backup set.

Backup set name

View the backup set name.

Properties

View the properties of the backup set.

See Also

Backing Up and Restoring Databases