This table allows you to configure snapshot file path settings for local custom snapshots. You can specify one row per snapshot file, or you can specify one location for all snapshot files using FileName=’MinionDefault’.

Note: SQL Server does not allow you to specify the snapshot log file location, and so neither does this table.

For more information, see “How to: Configure Custom Snapshots”.

 
Name Type Description
ID int

Primary key row identifier.
DBName varchar

Name of the origin database. ‘MinionDefault’ applies to all databases.

 

Valid values:
 <specific database name>
MinionDefault
OpName varchar

The name of the operation used.

 

Valid values:

CHECKDB

CHECKTABLE
FileName varchar

Name of the file. ‘MinionDefault’ applies to all files.

 

Valid values:
 <specific file name>
MinionDefault
SnapshotDrive varchar

Snapshot drive. This is only the drive letter of the snapshot destination.

 

IMPORTANT: If this is drive, this must end with colon-slash (for example, ‘M:\’). If this is UNC, use the base path (for example, ‘\\server2\’)
SnapshotPath varchar

Snapshot path. This is only the path (for example, ‘SnapshotCheckDB\’) of the snapshot destination.
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.
IsActive bit

Whether the current row is valid (active), and should be used in the Minion CheckDB process.
Comment Varchar

For your reference only. You can label each row with a short description and/or purpose.