Best Practice to Backup Replicated Virtual Machine

VMware specific discussions

Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Thu Dec 25, 2014 8:56 am

Hi Guys,

I want to backup my virtual machine using Veeam but that machine is also being replicated to different datastore (on same location) using VMware vSphere Replication.

My question is typically for SQL Servers. I'm already replicating my SQL Server through VMware Sphere Replication (MS VSS enabled). Now I also want to backup my SQL Server through Veeam by using it's "application aware image processing" *(VSS) feature.

Is there any best practice to achieve this? Do I have to disable VSS on VMware vSphere Replication and just enable it on Veeam?

Regards,

MQ
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby Vitaliy S. » Thu Dec 25, 2014 10:04 am

Hi Mobin,

My recommendation would be to do everything by Veeam, cause not only it will allow you to control everything from the same console and avoid job overlaps, but you can additionally configure log truncation/application-aware image processing in Veeam.

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Sun Dec 28, 2014 7:38 pm

Hi Vitaliy thanks for the reply and I appreciate your suggestion, but I'd carry on using VMware vSphere Repication for SQL my Servers. I'd just like to backup them using Veeam, so if replication failed I can recover VM from Veeam.

Is there any best practice I can use both product (Veeam + vSphere Replication) without any issue?

Regards,

MQ
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby Vitaliy S. » Sun Dec 28, 2014 9:15 pm

In this case the best practice would be to avoid job overlaps and manage logs truncation via one tool only.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Mon Dec 29, 2014 4:26 pm

Hi Vitaliy thanks for the suggestion. I've configured SQL Native backups on local drive on SQL Server itself. At the moment I'm only backing up the backup drive through Veeam and all other drives ar excluded in Veeam backup. SQL Server is being replicated using VMware vSphere Replication using MS VSS. Now I'm planning to setup SQL backups on shared network drive instead of local drive and then backup the network drive through Veeam.

Can I backup whole SQL Server using Veeam (application-aware image enabled) while it's also being replicate through VMware Replication or do I need to choose only one option whether to go for Veeam backup or VMware Replication? Just so you know RPO is set to 15 mins on vSphere Replication (MS VSS enabled) and I assume backing up whole VM through Veeam (application-aware image enabled) would overlap logs truncation as it would conflict between those 15 mins.

Please suggest. Thanks
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby Vitaliy S. » Mon Dec 29, 2014 4:58 pm

Application-aware image processing (including logs truncation) should be handled by one application. Since you're already doing to with SQL native backups, I don't see many reasons for doing the same thing via vSphere replication and Veeam.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Tue Dec 30, 2014 12:09 pm

Hi, for now on I'll just keep it going as it is,... so Veeam only backup the backup drive and vSphere Replcation to replicate it on different datastore. In future planning I'll test to backup whole VM through Veeam (application-aware image processing) and vSphere Replication (MS VSS disabled).

I'll update the result if I found any issues while followig the above method.


Cheers
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby Vitaliy S. » Tue Dec 30, 2014 12:42 pm

With Veeam you can even use SQL backup jobs to backup transaction logs, so using native tools will not be required either.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Tue Dec 30, 2014 4:28 pm

Vitality, in native backup we get backup files in .bak format (stored on one of the local drives) which we then backup through Veeam. Also .bak format files are easily available to restore instead of restoring .mdf and .ldf files which Veeam offers. That's the main reason we've configured native backups so we can backup .bak files through Veeam.

I'm just wondering if backing up Full SQL Server through Veeam (application aware image processing disabled) and also replicating Full SQL Server through vSphere Replication (MS VSS enabled) would cause any issues.

Cheers
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby v.Eremin » Wed Dec 31, 2014 11:15 am

What Vitialiy was talking about is a new feature of version called transaction log backup– additional tiny job that takes care of SQL logs. The log replay is also just a matter of using Veeam SQL Explorer.

Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Thu Nov 05, 2015 8:36 am

Hi Guys,

With the above scenario I had so many issues using VMware Replication for SQL Server and File Server, so I've stopped using VMware replication and use want to achieve both backup and replication through Veeam. So here is the setup.

SQL Server with running multiple websites DB on it and the recovery mode is "Full". Now I need to setup Veeam Backups, so I have a full backup of a VM and also want to setup Veeam replication on same site between different datastores .We require Restore to a point and time (not to a specific transaction).

I've a script setup on my SQL Server which take native SQL backups (in .bak format) after every 4 hours. Could Veeam provide me with something using Logs Truncate so I can disable SQL native script.

I'm looking for a best practice using Veeam which would let me able to restore in case of disaster(using Veeam Replication) and also want to have SQL DB backups in case I need to restore particular DB using Veeam SQL Explorer or FLR.

Also I'd like to setup File Server Veeam Replication between different datastores (currently it's being backed up by Veeam as a Full VM backup)

Regards,

Mobin
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby kawiMTF » Thu Nov 05, 2015 8:43 am 1 person likes this post

Hi mobin

You can set theup the backup of your SQL DB directly in the backup job where SQL VM is.

Check the Veeam Helpcenter for a detailed guide:
http://helpcenter.veeam.com/evaluation/ ... store.html

With this backup there is no need for additional scripts within the VM.
Best regards,
Karl

-----------------------
Veeam Platinum Partner
Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
vExpert / VCA6-DVC / VCA5-DVC / VCA5-Cloud
MCP / MCSA 2012
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
kawiMTF
Veeam Vanguard
 
Posts: 116
Liked: 20 times
Joined: Tue Jan 06, 2015 10:03 am
Location: Switzerland
Full Name: Karl Widmer

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby PTide » Thu Nov 05, 2015 9:00 am 1 person likes this post

Hi mobin,

Also I'd like to setup File Server Veeam Replication between different datastores (currently it's being backed up by Veeam as a Full VM backup)

so I have a full backup of a VM and also want to setup Veeam replication on same site between different datastores .We require Restore to a point and time (not to a specific transaction).
I'd suggest you to use replica seeding in order to avoid taking a big snapshot of your VM. You can use your Full backup to create your replica in a faster and easier way. If you don't want to touch you production VM at all after the backup has been taken then you might want to choose replica from backup option.

I've a script setup on my SQL Server which take native SQL backups (in .bak format) after every 4 hours. Could Veeam provide me with something using Logs Truncate so I can disable SQL native script.
Karl is right - you can set up you backup job in such way that VM restore points are taken once a day while transaction logs are backed up more frequently (every 15 minutes, for example). There are options to truncate/copy/do not process logs. Please take look at this article.

Please note, that point-in-time recovery cannot be used with backup copy jobs and tape jobs, see this thread for details.

Thank you.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby mobin.qasim » Fri Nov 27, 2015 4:07 pm

@KawiMTF Thanks I'm currently testing this in my environment. Veeam Explorer for SQL looks perfect so far no issues.

@PTide My File Server Full backup is being backed up on the NAS but I want to setup it's replication onto a different and faster datastore which exists in my vCenter environment. I assume replica seeding would only work if I'd want to setup File Server replication onto same storage as of the full backup (on NAS).

In vSphere Replication I was replicating my File Server from one datastore to another and both datastores sitting on same vCenter. Now I'd like to setup similar by using Veeam Replication. Could you please guide what could be the best practice setting this up.

Regards,

Mobin
mobin.qasim
Enthusiast
 
Posts: 58
Liked: 1 time
Joined: Wed Jun 19, 2013 7:23 pm
Full Name: Mobin Qasim

Re: Best Practice to Backup Replicated Virtual Machine

Veeam Logoby PTide » Fri Nov 27, 2015 4:46 pm

I assume replica seeding would only work if I'd want to setup File Server replication onto same storage as of the full backup (on NAS).
Please take a look at remote replica from backup feature.

replicating my File Server from one datastore to another
You can specify destination datastore in replication job wizard.

Thank you.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Next

Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 10 guests