Verifying backups

After you create a backup, verify that you can query the virtual machine backups and the database backups from the Data Protection for Microsoft SQL Server interface.

About this task

You can recover one or more Microsoft SQL databases based on your recovery point objectives.

Procedure

  1. From Microsoft Management (MMC), select a Microsoft SQL Server.
  2. Click the Recover tab.
  3. Select View > Databases. A list of Microsoft SQL Server database backups that can be restored is displayed.

    Microsoft SQL Server databases that are backed up with Data Protection for VMware are identified with the backup method vmvss. Microsoft SQL Server logs that are backed withData Protection for Microsoft SQL Server are identified with the backup method Legacy.