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.
|