White Papers

21 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
Restore selected database – Performs an “in-place” database restore and automatically starts a Selective
Database Restore of only the chosen database files. If other databases share the smart copy volumes, the
Selective Restore operation protects other database components from being damaged during the restore
process.
Restore All – Performs a restore of all the data in the Smart Copy and brings the database online. If there
are multiple databases included in the Smart Copy set, for example, in a collection, all the databases are
restored to the point-in-time of the Smart Copy and brought online.
Restore as New – Performs a side-by-side restore to a new location of all the data in the Smart Copy and
brings the database online. If there are multiple databases included in the Smart Copy, for example, in a
collection, all the databases are brought online as copies of the originals to the point-in-time of the Smart
Copy.
Figure 11 Snapshot Smart Copy Restore Options with ASM/ME
The following sections discuss SQL Server database restore scenarios and how to apply each of the
restore options. Some scenarios may use multiple Smart Copy restore options but each option can have a
different effect on the restore. Please read through the next sections carefully to understand how each
Smart Copy restore option will affect the SQL Server database environment.