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