PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Instant access recovery overview

Instant access recovery enables you to access a live-mounted SQL database from protection storage without restoring the virtual machine or SQL database.

This type of operation is useful for database administrators who must use or query a SQL database before restoring the database due to time and resource constraints.

This feature also supports the migration of mounted disks containing live mounted databases from protection storage to production datastore.

When you initiate instant access recovery, the operation locates the corresponding backup virtual disks and mounts them from the DD protection storage. The operation locates the SQL Server database selected by the database administrator from mounted disks and connects the database to the SQL Server instance. If transaction logs were selected, the transaction logs are replayed against the instant access database.