veeam backup and replication best practices

When backing up AlwaysOn availability group make sure all cluster nodes are processed by the same backup job for transaction logs processing and restores to work properly. Please check the Veeam User’s Guide sections to get the more information about SQL backup configuration SQL Always-on Availability Group No additional configuration is required to backup the standalone SQL server, you can configure the backup with application aware processing to take the backup of SQL server with the databases. Job configuration Virtual Machine Image Level Backup Standalone SQL Server Under the Paging File object, add the counter: %Usage (Instance: Total)Ĭheck Microsoft article “Monitor Memory Usage” to validate the health status of SQL Server.Under the Physical Disk object, add the counters: Avg.Under the Processor object, add the counter: %Processor Time (Instance: Total).Under the Memory object, add the counter: Available MB.Add below objects verify the performance:.Check and confirm writers are “Stable with no errors”.Īs backup is I/O intensive operations check the SQL server performance status before start taking the backup.Type “vssadmin list writers” and press enter.Verify all the writers are in health state.Type “vssadmin list providers” and press enter.Open a command prompt as administrator.The following section will provide the best practices to verify SQL Server for the smooth and fast backup.Ĭheck the status of VSS writers and providers: AlwaysOn Clusterless Availability Groups are not supported.AlwaysOn Availability Groups based on multiple Failover Cluster Instances are not supported.Cluster disks used as CSV are automatically excluded from backup. Backup of CSV (Cluster Shared Volumes) is not supported.Veeam Agent has additional limitations applied to specific configurations:

Note: Please read the white paper on benefits of using SQL Always-on Availability Groups for Virtual Environment This site uses Just the Docs, a documentation theme for Jekyll. Restoring VMs to an HPE 3PAR with thin disks.Backup Repository HA using Windows Storage Replica.

Veeam backup and replication best practices