1-800-691-1991 | 9am - 8pm ET

How to Backup Your Veeam ONE SQL database

KB ID: 2356
Product: Veeam ONE 11, Veeam ONE 10, Veeam ONE 9.5, Veeam ONE 9.0, Veeam ONE 8.0
Published: 2017-10-10
Last Modified: 2021-03-31


This article contains instructions on backing up your Veeam ONE SQL database.


This is useful when you have to do a backup before an upgrade or in case you have been asked to provide a backup of Veeam ONE database to Veeam Support for further in-depth analysis.


There are several ways of creating a backup of the database.

Using Veeam ONE Settings Utility (works for local SQL instances only)

To open Veeam ONE Settings utility use one of the options presented below:

  • Open VeeamOneSettings.exe in C:\Program Files\Common Files\Veeam\Veeam ONE Settings
  • Open the utility via Veeam ONE Monitor client > Options > Server Settings > Other Settings. Once you open the tab, you will find Support utility section. Click the Launch button.
To back up the Veeam ONE database to a .BAK file, click Create Backup and specify the location for the database backup file.User-added image

Using SQL Server Management Studio
  1. Open Microsoft SQL Server Management Studio with administrator permissions (may need to be installed separately KB1761). 
  2. Connect to the ServerName\Instance of the server that has the DB you want to back up.
  3. Expand the Databases tab to get to the DB you want to back up. 
  4. Right click the desired DB > Tasks > Back Up.
  5. Set Backup Type to Full
  6. Specify the database file destination by choosing Back up to Disk option > Add the destination path to save the database backup.
  7. Go to Backup Options and set Set backup compression to Compress backup to reduce the database file size (the option is not mandatory).
  8. Click OK to start the Backup process.

Using SQL command line

In case you do not have the Management Studio installed, Veeam database can be collected using the SQLCMD utility:
  1. Open Veeam ONE Monitor client and check the lower part of the window for the SQL instance name and Veeam database name. Alternatively, check the same via Veeam ONE Settings Utility. See Using Veeam ONE Settings Utility (above) for access instructions. 
  2. Open Windows command line or PowerShell prompt and run the following command to create a backup file:
    for default instances:
    sqlcmd -S SqlServerName -Q "BACKUP DATABASE [DbName] TO DISK=N'C:\backups\VeeamONEDB.bak'"

    for named instances:
    sqlcmd -S SqlServerName\SqlInstanceName -Q "BACKUP DATABASE [DbName] TO DISK=N'C:\backups\VeeamONEDB.bak'"
Note: In case you have SQL server authentication enabled you may define username using '-U' parameter
sqlcmd -U Username -S SqlServerName\SqlInstanceName -Q "BACKUP DATABASE [DbName] TO DISK=N'C:\backups\VeeamONEDB.bak'"
KB ID: 2356
Product: Veeam ONE 11, Veeam ONE 10, Veeam ONE 9.5, Veeam ONE 9.0, Veeam ONE 8.0
Published: 2017-10-10
Last Modified: 2021-03-31

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.

ty icon

Thank you!

We have received your request and our team will reach out to you shortly.


error icon

Oops! Something went wrong.

Please go back try again later.