- Veeam Support Knowledge Base
- Veeam ONE Database Partitioning
Veeam ONE Database Partitioning
| KB ID: | 4175 |
| Product: | Veeam ONE | 11 | 12 | 12.1 | 12.2 | 12.3 | 13 |
| Published: | 2021-05-27 |
| Last Modified: | 2025-10-14 |
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
Oops! Something went wrong.
Please, try again later.
Purpose
This article documents the procedure for implementing database partitioning to improve the performance of Veeam ONE deployments where the database in use was first created using Veeam ONE 9.x or older.
Starting with Veeam ONE version 10, all newly deployed Veeam ONE databases are already configured with partitioning. However, Veeam ONE deployments that were upgraded from the older versions (8.x, 9.x) do not have database partitioning automatically applied, or may include the old version of database partitioning, which is recommended to be upgraded to the new one. For such databases, the modern database partitioning must be applied manually.
Solution
Implementing Modern Database Partitioning
- Stop the Veeam ONE services.
- Back up the Veeam ONE database.
- Download the Veeam ONE Partitioning SQL script:
MD5:
1F8DFD776A221917CD20AB49F060C5B3SHA1:
EF0358A2C4EE499443BA148A28F9A8817A2B3276- Execute the script against the Veeam ONE database.
Note: Depending on the size of the database, this process may take some time. You can check the progress of applying the partitioning in the SQL Server Management Studio "Messages" panel, next to the Results tab below the script editor. When the process is complete, all three tables will be partitioned and ready to use. - Start the Veeam ONE services.
More Information
If this KB article did not resolve your issue or you need further assistance with Veeam software, please create a Veeam Support Case.
To submit feedback regarding this article, please click this link: Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.