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.

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

(SQL Server 2005) The size of the component files. This size should closely match the size of a backup snapshot.

Data size

(SQL Server 2005) Size of the backup stream. Applies to databases only.

Page verification

(SQL Server 2005) 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

(SQL Server 2005) The attribute that is applied to the filegroup.

On-line/off-line

(SQL Server 2005) The status of the filegroup.

Path

(Database files only) The absolute path of the database file.