Question

Replication of a hyper-v Virtual Machine in which SQL Server is running

A

Hello,

I would like to know if it is recommended to use  Veeam Buckup and Replication Standard to replicate a hyper-v virtual machine in which sql server is running.

Thanks

3 comments

haslund
Userlevel 7
Badge +2

No problem, I strongly suggest enabling application-aware processing in the job.

 

See: https://helpcenter.veeam.com/docs/backup/hyperv/replica_vss_application_hv.html?ver=110

Check out my blog on https://rasmushaslund.com - Rasmus is a Veeam Certified Trainer and passionate about all community work.
wolff.mateus
Userlevel 7
Badge +1

Yeah, is it possible! Best practices that I ever take:

  • First replication on an outside hour production;
  • No low minutes in the first replications;
  • Backup before replication ever.
IT Lover | Veeam Legend | VMware vExpert | Blogger
Geoff Burke
Userlevel 6
Badge +2

Hi akd79,

 

I have done this many times never had any issues and have tested a lot too. As @haslund has pointed out very important to turn on application aware so that VSS is leveraged in Windows so that the database is a “ready” state for backup. Otherwise I believe it would be in “crash consistent” state, like pulling the plug.

 

cheers

 

 

 

VMCA, VMCE, CKA (Certified Kubernetes Administrator)

Comment