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

How to manually backup a SQL DB

KB ID: 1471
Published: 2012-01-06
Last Modified: 2021-11-10
Languages: IT | FR

Purpose

Compressing the database backup will result in quicker uploads.
This article documents how to manually backup a Microsoft SQL Database.

Solution

Using SQL Server Management Studio

  1. Open Microsoft SQL Server Management Studio (May need to be installed separately)
  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, then from the context menu select Tasks > Back Up...
tasks backup
  1. Set [ Backup Type ]  to Full, and ensure the output is to a single file on Disk.
Full backup to single file on disk
  1. Go through the rest of the General and Options tab information to set the options to what you want. 
  2. Click OK to start the Backup process.

Using sqlcmd

If SQL Server Management Studio is not installed, the Veeam database can be collected using SQLCMD:

  1. Check the name of the SQL instance and Veeam database in the Windows registry
    • HKLM\SOFTWARE\Veeam\Veeam Backup and Replication\SqlDatabaseName
    • HKLM\SOFTWARE\Veeam\Veeam Backup and Replication\SqlInstanceName
    • HKLM\SOFTWARE\Veeam\Veeam Backup and Replication\SqlServerName
  2. Open an Administrative Command Prompt and connect to SQL instance:
    SQLCMD -S (SqlServerName)\SqlInstanceName
    

    User-added image
    Note: In case you have SQL server authentication enabled you may define username using '-U' parameter.

  3. Backup the Veeam database:
    BACKUP DATABASE SqlDatabaseName TO DISK = 'C:\VeeamDB.bak'
    GO
    

    User-added image

More information

Alternatively you can copy the .MDF (database file) and .LDF (database temp file) to a different location.  The default path for these files are "C:\Program Files\Microsoft SQL Server\MSSQL10_50.'YourInstanceName'\MSSQL\DATA\" where "YourInstanceName" is the name of the SQL instance.
For more information on how we process the collected data, please visit: vee.am/processing_of_personal_data
KB ID: 1471
Published: 2012-01-06
Last Modified: 2021-11-10
Languages: IT | FR

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.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case

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.
Thank you for your interest in Veeam products!
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please try again later.