Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Instant access recovery use cases

Instant access recovery to a SQL Server database is useful in a number of cases, including ad hoc queries, health checks, disaster recovery, and development tests.

Ad hoc queries

When you need a history of changes, perform an instant access restore to mount SQL databases for browsing and finding historical data.

With SQL instant access recovery, you can browse the history of changes in specific rows or tables quickly by running the SQL queries on the mounted database. You can also run the SQL queries to move data from a mounted database to a live SQL database.

Health checks

You can validate the SQL database health by running health check queries on the live mounted database.

By performing health checks on the mounted database instead of the live database in the production environment, you can reduce the impact on production resources while checking the health status.

Disaster recovery

During a disaster recovery, SQL instant access recovery provides temporary access to SQL data while the database is down.

You can connect the live mounted database to a SQL Server instance for urgent queries.

Development tests

Merging changes to the production database is an operation with a risk of breaking applications.

With SQL instant access recovery, you can use a replica of the database to test changes before you upload them to the live production database.


  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\