Veeam Explorer for Microsoft SQL Server supports database files obtained from the VeeamZIP file or from SQL server VM backup or replica. So, the following operations should be performed:
- Obtain database file from the latest or specified restore point (backup, replica or VeeamZIP file) by means of Veeam Backup & Replication.
- Add this database to the Veeam Explorer scope.
You can carry out these two steps in a fully automated way by using the Microsoft SQL Server Database Restore wizard (described later in this guide). In this case, Veeam Backup & Replication will automatically obtain the database from the backup and open it in Veeam Explorer for Microsoft SQL Server.
Alternatively, you can perform these steps manually: first, obtain the database files from the backup using any other Veeam recovery option (for example, Windows guest OS recovery), then locate the necessary database and add it to Veeam Explorer scope. This course of action is described in the next sections.