Minion CheckDB let’s you create custom snapshots for CheckDB and CheckTable operations. Here I’ll show you the basics of how to set it up. To download Minion CheckDB and to see full docs, go to www.MinionWare.net
Notes for this video:
Custom snapshots are only supported on SQL Server Enterprise up to 2016; 2016 SP1 lets you do it in Standard.
Why would you want to create a custom snapshot? On busy databases, internal snapshot can fill up.
1. Tell MC you want to take custom snapshot.
2. Tell MC where you want the files to go.
— 1, Minion.CheckDBSettingsSnapshot —
This table accepts default rows (DBName=MinionDefault). The most important columns: CustomSnapshot, DeleteFinalSnapshot, SnapshotFailAction.
(Why would a snapshot fail? Edition doesn’t allow it, or disk doesn’t exist, or acct doesn’t have permissions to create files or folders, etc.)
— 2, Minion.CheckDBSnapshotPath —
Allows default rows: DBName=MinionDefault (all databases) and FileName=Miniondefault (all files). You can insert DB level overrides, too. (Note that process creates the folder for you.)
Note: See Minion.CheckDBLogDetails for information on CheckDB/CheckTable runs. You can see custom snapshots in the log by noting the CheckDBNames (snapshot name) that are different from the DBNames.