Microsoft SQL Server
For the Veeam ONE database, use a server that meets the following requirements.
Hardware Recommendations
Specification | Veeam Backup Data Only | Virtual Infrastructure |
|---|---|---|
CPU, RAM | CPU and RAM sizing requirements are the same as for the Veeam ONE Server. Note: the Standard Edition of SQL Server does not allow the use of more than 4 CPU sockets (or more than 24 cores in total). If the recommended amount of cores or sockets exceeds these limits, SQL Server Enterprise Edition must be used. Important! These requirements assume that the Veeam ONE database is hosted on a dedicated Microsoft SQL Server. If the SQL Server is shared by several applications, compute requirements will be higher. To calculate the amount of resources required by other applications, see application-specific sizing recommendations for Microsoft SQL Server. | |
Disk | Install the OS and Microsoft SQL Server on different drives. OS Drive: 50 GB Application drive: Use the Veeam ONE Database Calculator to size application data. With partitioning scripts, you will have the following distribution of the Veeam ONE database size:
Size the following tables in accordance with Microsoft SQL Server recommendations:
Other: SSD RAID storage with broadband connectivity must be used for the TempDB table. | |
Other | If you use a virtualized Microsoft SQL Server, this server must run on a separate LUN/datastore from Veeam ONE Server. | |
Software and OS Requirements
Specification | Requirement |
|---|---|
Software | Microsoft SQL Server (Full and Express Editions):
Reporting Services (optional):
|
Database Size
To calculate an expected size of the Veeam ONE database, use the Veeam ONE Database Calculator. The calculator helps estimate disk space required to store VMware vSphere, Microsoft Hyper-V and Veeam Backup & Replication data.
For details, see https://www.veeam.com/kb2246.