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.