This IBM® Redpaper gives a example of procedures to restore the Microsoft® SQL 2000 and 2005 using SnapManager®.There are options discussed that depend on the type of disaster, the type of data recovery, and the type of system on which the disaster applies.

Recovering a snapshot with SnapManager for SQL
The process to restore a SQL database requires DBA skills and knowledge of the SnapManager product. In the SnapManager Administration guide several restore options are described, followed by a step-by-step instruction. This paper does not describe those steps.

Restoring a snapshot with SnapManager
In this section we discuss the steps taken in a test scenario as executed during a disaster recovery test. Log on to the SQL server (in this case SQL2000 PDC1DB005) with SA_snapdrive and start Enterprise Manager for SQL.
1. Select properties of the database that you want to restore.
2. Set the database in single user mode.
3. Close Enterprise Manager.
4. Stop the (remote) services that connect to the database. Use the process information of SQL Enterprise Manager to find active processes.
5. Start SnapManager for SQL. Depending on what database you must restore (and the sort of backups taken for that database), the procedure may differ.

Download pdf Disaster Recovery Procedures for Microsoft SQL 2000 and 2005 using N series