Apply Transaction Logs to an SQL Database on a Recovered QR Volume
Before You Begin:
- Ensure that you have installed the SQL Server
iDataAgent and
the Quick Recovery Agent on the same
SQL Server.
- Ensure that you have a QR Volume and a transaction log backup of the SQL Server Database
taken after QR Volume creation.
- Ensure that the database to be restored is in NORECOVER mode.
Required Capability: See
Capabilities and Permitted Actions
To
apply transaction logs to a recovered QR Volume with SQL Server data:
- Perform a QR Recovery to recover the SQL data from your
QR Volumes. Refer to
Recovering QR Volumes
for procedures on performing a QR Recovery.
- After recovering the SQL Server data from your QR
Volumes, access the CommCell Console, and begin any SQL Server restore
procedure.
- In the
SQL Restore (General)
dialog box, select Step Restore as the Restore Type.
- From the Restore Time list, select the desired log.
The iDataAgent will apply the
selected log and all logs that occurred prior to the selected log.
- Select the desired Recovery Type.
- When restoring encrypted data, refer to
Data Encryption.
- Continue your restore.