White Papers

40 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
Figure 27 Figure 27: Thin Clone Database Process Flow
8.3 Step by Step Template Database Creation
First prepare the database copy for template volumes.
1. Use ASM/ME to create a Clone Smart Copy of the SQL database being used
2. Restore the Clone Smart Copy using the Restore All as New method
a. Be sure to check the “Make database READ-ONLY after attach” check box
The database should show up as a read-only copy of the database in SQL Server Management Studio,
Figure 28.
Figure 28 Read-Only Database in Management Studio
Now the database volumes can be converted to template volumes using the PS Series Group Manager
GUI.
Create DB
Clone Smart
Copy
Restore DB
Clone as New
(Set Read-Only Flag)
Locate Name
of Clone
Volumes
Convert to
Template
Volumes
Verify iSCSI
Initiator Login
Refresh
Services on
SQL Instance
Create DB
Copies Using
Thin Clones