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
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Performing Microsoft SQL Server table-level recovery to a virtual machine

To recover table-level data, you can use the SSMS plug-in to first mount the backup, and then use ItemPoint for Microsoft SQL Server to browse and restore the tables.

NOTE:You can only mount and restore tables from the level full backups.

Table-level restore operations mount the application-aware virtual machine image backup on the target virtual machine.

The Microsoft application agent sends a request to the PowerProtect Data Manager server to mount the selected backup.

When the backup is mounted, the VMDK images from the virtual machine image backup are added to the target-virtual machine and assigned mount points.

The backup is mounted with the PowerProtect Data Manager server for 4 hours by default. The valid range for the mount timeout is between 1 and 24 hours, after which the mounted backup must be dismounted.

NOTE:When backup images are mounted, you cannot start a new session of backup, database restore, table-level restore, or instant access.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\