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

How to Backup Your Veeam ONE SQL database

KB ID: 2356
Product: Veeam ONE 11, Veeam ONE 10a, Veeam ONE 9.5, Veeam ONE 9.0, Veeam ONE 8.0
Published: 2017-10-10
Last Modified: 2021-06-14

Challenge

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

Cause

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.

Solution

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

OR

  • 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. 
  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 10a, Veeam ONE 9.5, Veeam ONE 9.0, Veeam ONE 8.0
Published: 2017-10-10
Last Modified: 2021-06-14

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later
Knowledge base content request
By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Policy.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

ty icon

Thank you!

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

OK

error icon

Oops! Something went wrong.

Please go back try again later.