Skip to main content
Solved

Backup SQL encrypted databases


De Cock
Forum|alt.badge.img

Hi All,

I look for confirmation if Veeam B&R supports backups of SQL Encrypted databases on a Always ON environment. This with standard backup (vmware agent less) and via a a job with the windows agent both with application awarness.

Thanks,
Benny

Best answer by matheusgiovanini

Yes, your specific setups are supported:

  • Standard VMware agentless backups of SQL VMs in an Always On Availability Group, with Application-Aware Processing

  • Windows Agent backup jobs across the cluster nodes, with Application-Aware Processing

Both configurations are fully compatible with SQL databases encrypted using Transparent Data Encryption (TDE) or Always Encrypted, since Veeam uses native SQL Server backup APIs.

The only caveat, in case you decide to use the native Veeam plug-in for Microsoft SQL Server (instead of the methods mentioned above), is that:

  • Databases using TDE do not support compression when backed up via the plug-in

  • Differential backups are not supported on secondary replicas

However, this limitation does not apply to the two scenarios you mentioned (agentless VMware and Windows Agent with Application-Aware Processing).

 

You can see more here.

 



 

View original
Did this topic help you find an answer to your question?

1 comment

matheusgiovanini
Forum|alt.badge.img+6

Yes, your specific setups are supported:

  • Standard VMware agentless backups of SQL VMs in an Always On Availability Group, with Application-Aware Processing

  • Windows Agent backup jobs across the cluster nodes, with Application-Aware Processing

Both configurations are fully compatible with SQL databases encrypted using Transparent Data Encryption (TDE) or Always Encrypted, since Veeam uses native SQL Server backup APIs.

The only caveat, in case you decide to use the native Veeam plug-in for Microsoft SQL Server (instead of the methods mentioned above), is that:

  • Databases using TDE do not support compression when backed up via the plug-in

  • Differential backups are not supported on secondary replicas

However, this limitation does not apply to the two scenarios you mentioned (agentless VMware and Windows Agent with Application-Aware Processing).

 

You can see more here.

 



 


Comment