How to use SQL Management Studio to Apply SQL-Based Hotfixes to the Veeam ONE Database

Purpose This article documents applying a SQL query script-based hotfix for the Veeam One database. Solution Identify the Location of the Veeam ONE Database If Veeam ONE is installed, open the Veeam ONE Settings Utility to view the current SQL Server settings. C:\Program Files\Common...

Veeam Availability Console 3.0 upgrade considerations

Challenge Under certain circumstances upgrade to Veeam Availability Console v3 may fail leaving configuration database in a non-consistent state Cause The issue occurs when one or more tenants from the underlying Cloud Connect server have duplicated backup quotas on the repository. Solution Befor...

SQL Log Files (LDF) Not Smaller After Truncation

Challenge After Veeam Backup & Replication or Veeam Agent for Microsoft Windows successfully truncates a SQL Server Database with Application-Aware Processing enabled, the SQL Log File .ldf does not become smaller. Cause This is due to the fact that the LDF file itself is a container, when...

Installing Microsoft SQL Management Studio

Challenge Sometimes database edits are required to correct issues with Veeam ONE or Veeam Backup & Replication software. Cause Microsoft SQL Management Studio can be used to troubleshoot Veeam databases or install database hotfixes. Solution The latest release of SQL Server Management Studio is...