Veeam config DB check tips
Veeam config DB check tips
It may happen that Veeam’s support engineer ask you to perform a check of the Veeam DB.
First of all, you need to find a mainenance window and to stop all veeam services, with the gui or this powershell (elevated) command:
Get-Service Veeam* | Stop-Service -Force
after that, open Sql Management Studio, connect to the VeeamBackup’s DB server, open a query window and issue:
ALTER DATABASE VeeamBackup SET READ_ONLY;
dbcc checkdb (VeeamBackup)
this will produce an output that’s interesting for the support engineer. After sending it, you’ll have to put the DB in a working status before to start Veeam services:
ALTER DATABASE VeeamBackup SET MULTI_USER;
ALTER DATABASE VeeamBackup SET READ_WRITE;
they will “open” the DB for access&write, and allow Veeam services to start.