Viewing active copies of Microsoft SQL databases

To be able to view active copies of Microsoft SQL databases with Data Protection for SQL, you must run all primary and subsequent incremental backups of the SQL databases by using Data Protection for VMware with application protection.

If you used application protection for the primary backup of Microsoft SQL databases, but did not use application protection for the subsequent incremental backups, no valid active backups can be used for individual SQL database restore operations. Data Protection for SQL examines the virtual machine backup and can display only the SQL databases from the virtual machine backups that were successfully backed up with application protection.

Ensure that you enable application protection when you run the primary backup and any subsequent incremental backups of the virtual machine that hosts the Microsoft SQL application. This method ensures that the active copies of SQL databases that you backed up from a virtual machine can be displayed by Data Protection for SQL.