Data Protection for Microsoft SQL Server updates V8.1.0

This document provides information about what's new or what has changed in Data Protection for Microsoft SQL Server version 8.1.0.

What's new

Mount VSS snapshot backups as read/write

You can mount local VSS snapshot backups as writable VSS snapshots. This enables you to run granular restore operations (for example, restores of individual tables or table rows) from the database backup without needing to do a full database restore. You can also use the snapshot as a clone of the production database.

The following mount options are available for your writable mount:

  • Mount read/write (modifies backup, applies to COPYFULL backups only)

    For VSS providers that support transportable shadow copies, you can mount a COPYFULL type backup as read/write. After mounting, your COPYFULL backup is marked as modified and while you can mount it again in the future, this backup can no longer be used for full database restores. However, it can be used for granular restore operations or serve as a clone of the production database. All databases on the snapshot volume that are mounted as read/write are marked as modified.

  • Mount read/write (without modifying backup)

    You can mount a read/write copy of your backup where you can modify the copy without invalidating the backup. With this option, you can mount writable VSS snapshots of FULL or COPYFULL backups. This option is only available for SAN Volume Controller (SVC) devices and requires IBM® System Storage® Support for Microsoft Virtual Disk and Volume Shadow Copy Services version 4.12 or later.

For more information, see Mounting SQL Server backups.
Microsoft SQL Server 2016
Microsoft SQL Server 2016 is now supported.