Creating an SQL Server Snapshot

Prerequisites

• At least one SQL Server instance has been created on the storage system.
• The HyperSnap license is valid.

Context

A snapshot created for an SQL Server instance is actually a snapshot group. When you create a snapshot for an SQL Server instance, you actually create a snapshot for each LUN contained in the instance. You can choose Data Protection > Snapshot to view the snapshot of each LUN contained in an SQL Server instance.

Procedure

1. Log in to DeviceManager.
2. Choose Provisioning > Application > SQL Server.
3. Select the SQL Server instance for which you want to create a snapshot and click Create Snapshot.

   The Create Snapshot dialog box is displayed.

4. Set snapshot parameters.

   Table 5-5 describes the related parameters.

   Table 5-5 Parameters of an SQL Server snapshot

   Parameter	Description	Example Value
   Name	Name of an SQL Server snapshot. The name must be unique. The name can contain only letters, digits, periods (.), underscores (_), and hyphens (-). The name contains 1 to 31 characters.	SQLServerApp_001_Snap_001
   Description	Description of an SQL Server snapshot.	-
   Activate Now	If this option is selected, a snapshot is activated immediately after creation.	Activate Now

5. Confirm your settings.
   1. Click OK.

      The Execution Result dialog box is displayed, indicating that the operation succeeded.

   2. Click Close.

Follow-up Procedure

After SQL Server snapshots are created, you can select an SQL Server instance and click the Snapshot tab in Details. Then you can operate the snapshot of the SQL Server instance based on service requirements.