Question on SQL Databases

[jcofin13]

Right now i have a environment im looking which has VBR and VeeamONE v12. Id like to upgrade to 13. Both products use an external SQL server which hosts both databases.
I can see the VeeamBackup and VeeamONE database on that server but ai also see another database called VeeamBackupReporting. I am not sure what this is or if it is legacy. This setup did have Enterprise Manager at one time but that is since been removed/powered down. Perhaps its part of that?

I am not sure how to tell if it is in use or not or if it is needed.

Right now SQL is 2014 and i want to do an in place upgrade to 2019 so we can upgrade VeeamONE and then VBR to v13 (VeeamONE v13 doesnt support sql 2014). The SQL 2019 upgrade removes SQL Reporting services from the server entirely....so my thinking is that this VeeamBackupReporting db will be affected. I just need to make sure its old and not being used before i proceed with the upgrade.

Does anyone know how to tell or have any insight? This server was setup many many years ago (not by me) so i dont have the full history on it.

[vnikiforov]

Hello,

The VeeamBackupReporting database is used by Veeam Backup Enterprise Manager. You can use SQL Server Management Studio (SSMS) to check for active sessions and recent activity\modified date to confirm whether it is still in use.

In Veeam One v13 Microsoft SQL Server Reporting Services (SSRS) is required for Veeam ONE legacy reports only (VMware, Hyper-V and vCD):

Your planned upgrade order is solid. Microsoft SQL Server 2019 is supported by all three products in v13.
I recommend following the official upgrade guides for each product.
Upgrading Microsoft SQL Server first, then Veeam ONE, and finally Veeam Backup & Replication

Note:
After the Microsoft SQL Server upgrade, don't forget to update the database compatibility level for the VeeamBackup and VeeamONE databases to SQL Server 2019 (compatibility level 150).

Useful links:

• Upgrading SQL Database Engine Used by VBR (KB 4386)
• Upgrading to Veeam ONE (Help Center v13)
• Upgrading to Veeam Backup & Replication on Windows (Help Center v13)
• VeeamONE System Requirements (Help Center v13)
• VeeamONE SQL Server Requirements (Help Center v13)