Dell PowerVault DP600 User Manual

Page 74

How to Recover a SQL Database and Allow Additional Log
Backups

The DPM recovery process uses SQL Server functionality to recover a database such that all

uncommitted transactions are rolled back. The recovery process opens the transaction log to

identify uncommitted transactions. Uncommitted transactions are undone by being rolled back,

unless they hold locks that prevent other transactions from viewing transactionally inconsistent

data. This step is called the undo, or roll back, phase.

In some circumstances, the SQL Server administrator might require the database to be restored

in a mode that allows log backups to be selectively played back. Using DPM, you can recover a

database and leave it in a restoring state in which additional log backups can be applied to the

database.

To recover a database without transaction roll back

1. In DPM Administrator Console, click Recovery on the navigation bar.

2. Using the browse functionality, select the database to recover.

3. On the calendar, click any date in bold to obtain the recovery points available for that

date. The Recovery time menu lists the time for each available recovery point.

4. On the Recovery time menu, select the recovery point you want to use. You can select

any recovery point except Latest.

5. In the Actions pane, click Recover.

The Recovery Wizard starts.

6. On the Review recovery selection page, click Next.

7. Select Recover to original SQL Server location or Recover to any SQL instance, and

then click Next.

8. If you select Recover to any SQL instance, on the Specify recovery destination page,

specify the instance of SQL Server to which the database should be recovered.

9. On the Specify Database State page, select Leave database non-operational but

able to restore additional transaction logs.

10. Select Copy SQL transaction logs between the selected recovery point and latest

available recovery point, specify a copy destination for the transaction logs, and then

click Next.

DPM must have Write permission for the copy destination for the transaction logs.

11. Specify recovery options for network bandwidth usage throttling, SAN-based recovery,

and e-mail notifications, and then click Next.