Recreate Veeam ONE’s Database

Stop al VeeamONE services

get-service veeam* | stop-service

Drop the VeeamONE database from SQL and rename the database and log files.

1. Open SQL Server Management studio.

2. Create a service account for Veeam ONE and assign the following permissions to it:

  • Public role (default permissions)
  • CREATE ANY DATABASE permissions
  • db_owner role on the Veeam ONE database
  • db_datareader permissions on the master database
  • publicdb_datareaderSQLAgentUserRole permissions on the msdb database
  • [For Always-On Availability Groups] VIEW SERVER STATE permissions

NOTE: The Named Pipes protocol on the Microsoft SQL Server must be enabled.
NOTE: If the Veeam ONE database runs on a remote Microsoft SQL Server instance, with the Microsoft SQL Server and Veeam ONE components residing in the same workgroup, Microsoft SQL Server authentication will be required.

3. Create a new database using the account specified above.

4. Run the installation SQL script against the new database. The script can be found on the Veeam ONE ISO: Addins\SQLScript\VeeamOne.sql.

5. [For Always-On Availability Groups] Manually add the Veeam ONE database to the corresponding SQL AlwaysOn Availability Group (skip this step if you do not use SQL Server AlwaysON).

6. Install Veeam ONE using the specified Service Account and the database created earlier. If Veeam ONE is already installed, update the existing database server address (if needed) and the database name using the Veeam ONE Settings utility located in C:\Program Files\Common Files\Veeam ONE\Veeam One Settings\VeeamOneSettings.exe

KB2312: Veeam ONE Manual Database Creation