Reviewing the configuration
A sample setup containing the following object names is used to illustrate how to create, refresh, and restore a snapshot set for a specified SQL Server database.
Table: Object names used in SQL Server Quick Recovery tasks
| Name | Drive Letter | Object |
|---|---|---|
| billing | - | SQL Server instance name |
| billing_DB | - | component (SQL Server database name) |
| harddisk3 | - | Disk where the mirrors will be created |
| billing_DG | - | disk group name for the Billing disk group |
| billing_data | L: | volume for Billing database user data |
| billing_log | M: | volume for Billing database log |
| billing_FS | N: | volume for Billing FILESTREAM filegroups (if FILESTREAM is implemented) |
| billing_datasnap | S: | volume for Billing database user data snapshot |
| billing_logsnap | T: | volume for Billing database log snapshot |
| billing_FSsnap | U: | volume for FILESTREAM filegroups database snapshot (if FILESTREAM is implemented) |
| billing_DB.xml | - | name for the metadata file generated when the snapshot is created |
| tlog1.bak, tlog2.bak | - | log files saved at c:\backup prior to restoring |
Related information