About viewing the properties of the objects selected for backup
You can view the properties of any object in the Backup Microsoft SQL Server Objects dialog box by right-clicking the object. Table: Properties of the objects that are selected for backup describes the properties of objects that are selected for backup.
To view the properties of an object that is selected for backup
- Select File > Backup SQL Server objects.
- In the Backup Microsoft SQL Server Objects 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 backup
Property | Description |
|---|---|
Object type | Database, database filegroup, database file, or transaction log. |
Object name | Name of the object. |
Parent (database, instance, filegroup, etc.) | Name of the object's parent. |
SQL Server instance | SQL Server instance the object belongs to. |
File size | The size of the component files. This size should closely match the size of a backup snapshot. |
Data size | Size of the backup stream. Applies to databases only. |
Page verification | The type of SQL Server page verification that is configured for selected databases, filegroups, and logical files. The available values are: none, torn page detection, or checksum. |
Read-only/read-write | The attribute that is applied to the filegroup. |
On-line/off-line | The status of the filegroup. |
Path | (Database files only) The absolute path of the database file. |