Viewing properties of objects selected for restore
You can view the properties of any object in the Restore Microsoft SQL Server Objects dialog box by right-clicking the object. The properties are described in Table: Properties of the objects that are selected for restore.
To view the properties of an object that is selected for restore
- Select File > Restore SQL Server objects.
- In the Backup History Options dialog box, in the right pane, right-click an object and select Properties.
- When you finish, click OK.
Table: Properties of the objects that are selected for restore describes the properties that appear on the Backup properties tab.
Table: Properties of the objects that are selected for restore
Property | Description |
|---|---|
Object type | Database, database filegroup, database file, or transaction log. |
Object name | Name of the object. |
Parent filegroup | Name of the parent filegroup |
Parent database | Name of the parent database. |
SQL Server instance | SQL Server instance the object belongs to. |
Time backup started | The date and time the backup was started. |
Backup policy | Name of the policy that is used to perform the backup. |
Page verification | (SQL Server 2005) The type of SQL Server page verification that is configured for selected databases, filegroups, and logical files. The possible values are: none, torn page detection, or checksum. If multiple objects are selected, then a value appears only if all of these objects have the same verification property |
Method | The method that is used to perform the backup, standard backup, or snapshot. |
Type of snapshot method | If applicable, the snapshot method that was used for the backup. |
Image | The name of the backup image that contains the selected object(s). |
Full text catalogs directories | Full text catalog names and directories. |
This tab is provided for the transaction log and differential backups that are members of a full recovery set. When the recovery set tab is selected, the set of images that compose the recovery set is listed.
This tab is provided at the database level for SQL Server 2005 images. When the tab is selected, a list of the images that contain the most recent backups of each read-only filegroup is provided. If a complete set of read-only filegroups is not available or if the database does not contain any read-only filegroups, then an explanation is provided.