SQL Server Standard or a higher version should be deployed for the instance used by Veeam Backup & Replication instead of the SQL Server Express instance installed by default in large-scale environments. SQL Server Express has limitations on the database size, the amount of memory it can utilize, and the number of CPU cores it can use. For large-scale environments, these limitations can hinder performance and scalability, necessitating the use of the more capable SQL Server Standard or higher versions.
For an optimal configuration in a Veeam backup environment involving a remote repository, you need to deploy the Veeam Data Mover service both at the production site and at the remote target site. This setup ensures efficient data transfer by having a dedicated service to handle data read at the production site and another to manage data write at the remote site. This dual deployment minimizes network load and optimizes the backup process.
The described backup method is a 'forever forward incremental backup'. In this method, after an initial full backup, all subsequent backups are incremental, meaning they only record the data blocks that have changed since the last backup. These changes are then merged into the original full backup file to reconstruct the latest state of the virtual machine.
During SureBackup job execution, redos logs are created for each verified VM. These logs are stored on the datastore specified in the Virtual Lab settings. This location is chosen to capture and manage changes made to the VM while it is running in the SureBackup job.
Extreme compression involves a significant amount of processing to reduce the size of the backup file, which in turn can reduce the backup performance. This is because compressing data to such a large extent requires more CPU time and resources, leading to slower backup operations.