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.

Procedure

  1. From Microsoft Management Console (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 Microsoft Hyper-V are identified with the backup method vmvss.

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