- Veeam Support Knowledge Base
- How to apply a SQL script
How to apply a SQL script
Cheers for trusting us with the spot in your mailbox!
Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest
Purpose
Solution
To run a SQL script from a command line, perform the following steps:
- Save the script as *.sql file (e.g. script.sql) to local disk
- Make sure that no jobs are running
- Run the following command:
sqlcmd -S <SqlServerName>\<SqlInstanceName> -d <SqlDatabaseName> -i PATHTOSCRIPT\script.sql -o c:\resetresult.txt -I
- Restart the Veeam services
You may also run a SQL script from SQL Server Management Studio, right-click on your database and choose the “New query” option, insert the text from the file, and click Execute.
SQL Server Management Studio can be found here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Information about the Veeam Backup & Replication configuration database can be found in the registry under these registry values:
- HKLM\Software\VeeaM\Veeam Backup and Replication\SqlServerName
- HKLM\Software\VeeaM\Veeam Backup and Replication\SqlInstanceName
- HKLM\Software\VeeaM\Veeam Backup and Replication\SqlDatabaseName
If the script needs to be applied to the Backup Enterprise Manager database, please use:
- HKLM\Software\VeeaM\Veeam Backup Reporting\SqlServerName
- HKLM\Software\VeeaM\Veeam Backup Reporting\SqlInstanceName
- HKLM\Software\VeeaM\Veeam Backup Reporting\SqlDatabaseName
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
Spelling error in text
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
Thank you!
Your feedback has been received and will be reviewed.