White Papers

42 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
Figure 30 Locate Volumes Used for Template Volumes
Now that the volumes have been converted to template volumes in the PS Series Group Manager, services
will need to be refreshed on SQL Server host to recognize the template database. Do not restart these
services.
1. First refresh the Microsoft iSCSI initiator – Targets list and make sure the template volumes are
logged in (connected). Log into the template volumes if necessary.
2. Next refresh the SQL Server instance.
3. Bring the database online in the SQL Server instance.
a. If the database fails to online, refresh the SQL instance again.
4. Lastly, refresh the host in Auto-Snapshot Manager to recognize the changes.
Use ASM/ME to create Thin Clones of the created template database, Figure 31, and follow the steps
above in SQL Server Database Restore to a New Server section to distribute Thin Clone copies for space
efficient test and development environments.
Note: The Mount command is the only option available for thin clones from ASM/ME. Once mounted,
the thin clone can be attached manually to the SQL instance.