How to Backup Your Veeam ONE SQL database

KB ID: 2356
Product: Veeam ONE
Version: 8.x, 9.x
Published:
Last Modified: 2017-10-11

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 (may need to be installed separately): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
  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'"
 

5 / 5 (1 votes cast)

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Request new content

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!

Orphus system