This table keeps a record of snapshot files (one row per file). This includes files created as part of local custom snapshots. For more information, see “How to: Configure Custom Snapshots”.
 
Name Type Description
ID int

Primary key row identifier.
ExecutionDateTime datetime

Date and time of the operation.
OpName varchar

The name of the operation used: CHECKDB or CHECKTABLE.
DBName varchar

Name of the origin database.
SnapshotDBName varchar

Name of the snapshot database.
FileID int

ID of the file within database.
TypeDesc varchar

Description of the file type. E.g., ROWS, LOG.
Name varchar

Logical name of the file in the database.
PhysicalName varchar

Operating system file name.
Size bigint

The file size (in 8 KB pages).
IsReadOnly bit

Whether the file is read only, or not.
IsSparse bit

Whether the file is sparse, or not.
SnapshotDrive varchar

Snapshot drive. This is only the drive letter of the snapshot destination (in the format ‘M:\’, or if this is UNC, the base path (‘\\server2\’).
SnapshotPath varchar

Snapshot path. This is only the path (for example, ‘SnapshotCheckDB\’) of the snapshot destination.
FullPath varchar

The full path without filename. For example: “C:\SnapshotCheckDB\”.
ServerLabel varchar

A user-customized label for the server name. It can be the name of the server, server\instance, or a label for a server.
PathOrder Int

If a snapshot goes to multiple drives, then PathOrder is used to determine the order in which the different drives are used.

 

IMPORTANT: Like all ranking fields in Minion, PathOrder is a weighted measure. Higher numbers have a greater “weight” - they have a higher priority - and will be used earlier than lower numbers.
Cmd varchar

The snapshot’s “CREATE DATABASE” statement used.
MaxSizeInMB float

The size of the snapshot file (not of the entire snapshot), in MB.