White Papers

27 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
For databases included in a Smart Copy collection, any individual database in the collection may be
restored at any time. The advantages of using database Smart Copy collections are:
 A single schedule can create Smart Copies of many databases
 If one of the databases in the collection fails, ASM/ME allows a selective restore of that one
database using the Restore selected database option.
 In the event of a volume failure, all the databases sharing the volume can be restored together
using the Restore All option.
Note: During a volume restore using the Restore All option all the databases included in the collection
are placed into a “restoring” state during the restore process (Figure 15).
The selective restore process can take longer than an instant restore because of the data movement
operation that occurs in the background during the restore. The time it takes to restore the selected
database is directly affected by the size of the database files being replaced. With PS Series firmware v5.0
and later, this data movement operation is left to the SAN with SAN Data Copy Offload. This offers a much
faster data movement operation compared to a file system data movement.
Figure 15 SQL Server Database Collection Restoring