HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses - Manual (Page 76)

Recovering a SQL Database from a Remote Copy Backup Server
If a SQL database crashes at the site that holds the primary servers, you can recover the data from
the Remote Copy backup server at the remote site as long as it is set up in an identical manner to
the original production server.
NOTE: If you are performing a promote restore for volumes in a Synchronous Long Distance
Remote Copy relationship, you must manually stop Remote Copy before initiating the volume
promote restore.
1. On the backup server, use Recovery Manager to mount the virtual copy to the production
server.
2. Log onto the production server and stop the SQL instance and its dependent services.
3. From the mounted virtual copy, manually copy all necessary database and log files to the
corresponding database location.
4. Restart the SQL instance and its dependent services.
5. Log back onto the backup server and unmount the virtual copy.
76 Remote Copy for Recovery Manager