White Papers

25 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
6.4 Restore as New or “Side-by-Side” database restore
A side-by-side database restore can be extremely useful to recover object level data within a database
without taking the database offline to do so. In ASM/ME, a side-by-side restore of a SQL Server database
means importing and mounting the Smart Copy to a host as a new copy of the original database.
The Smart Copy option for a side-by-side SQL Server database restore is:
 Restore as New
This option imports the Smart Copy to the host and brings the database online as a new SQL Server
database. This option can also be used to restore a copy of the database to a new server host in your
environment, see Advanced Operations and Management later in this document.
During the restore process you can choose the drive letter or mount point on which to mount each
volume as well as rename the database copy, Figure 13.
Figure 13 Restore All as New
Note: When a snapshot Smart Copy is imported, any new writes to the imported object will continue to
consume snapshot reserve. It is best practice to use clone Smart Copies if an imported database Smart
Copy is intended to remain online for write operations.
The Restore as New operation can enable database object data or file recovery by performing a manual
copy or select/insert operation to copy the file or database object to the production database.
For table and row data recovery see the Microsoft article, How to retrieve a specific table or rows from
database backups or transaction log backups in SQL server: http://support.microsoft.com/kb/321836.