Host-based backup of VMware vSphere VMs.
Post Reply
StanoSedliak
Service Provider
Posts: 94
Liked: 8 times
Joined: Mar 20, 2018 6:31 am
Full Name: Stano Sedliak
Contact:

Backup of turned off VMs also SQL

Post by StanoSedliak »

Hi,

I would like to ask you for your experiences/opinion.
I would like to backup some VMs with the same OS (location A) and restore these VMs in second location (location B).

On some VMs is SQL running so I should do the application aware backup to have a consistent backup.

Would it be better if I shut down these servers in the location A -> make backup and restore on location B?
What would be better: to do backup of the powered off SQL server or online with application aware?

Thank you!

Br, Stani
PetrM
Veeam Software
Posts: 3229
Liked: 520 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Backup of turned off VMs also SQL

Post by PetrM »

Hi Stano! Welcome to our forum! There is no need to power off SQL servers because application-aware image processing provides a possibility to create consistent VM backups.
StanoSedliak
Service Provider
Posts: 94
Liked: 8 times
Joined: Mar 20, 2018 6:31 am
Full Name: Stano Sedliak
Contact:

Re: Backup of turned off VMs also SQL

Post by StanoSedliak »

Hi PetrM,

thank you for the answer. If the SQL server will be turned off and application aware turned off will be the SQL backup consistent if I restore the VM on another location?
For example if we do not have permissions to do the SQL application aware backup.

Thank you!
mma
Service Provider
Posts: 111
Liked: 21 times
Joined: Dec 22, 2011 9:12 am
Full Name: Marcel
Location: Lucerne, Switzerland
Contact:

Re: Backup of turned off VMs also SQL

Post by mma »

Is this some kind of a migration?

If yes and if you have SQL DB and application on different servers, I would recommend to shut down the servers.
Yes, the SQL backup is application aware and consistent, same for the application server - but the backups don't "match" each other.
There might be a transaction done in the application, which is not done on the DB restore because the backup is five mins older.
StanoSedliak
Service Provider
Posts: 94
Liked: 8 times
Joined: Mar 20, 2018 6:31 am
Full Name: Stano Sedliak
Contact:

Re: Backup of turned off VMs also SQL

Post by StanoSedliak »

Hi mma,

yes, I would like to use it like "migration".

My concern is that if I turn off the SQL server and also the others that I can not use VSS to run application consistent SQL backup. If the servers would be shut down I can just make a "normal" VM backup.
I didn't test if SQL server is down and VM backup will be done (without app. aware) if after the restore the SQL server will be consistent.
If server will be off app. aware will not work, need I turn off app. aware function in the backup job? thank you!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of turned off VMs also SQL

Post by foggy »

If the server is shut down, then there's no need for app-aware processing, since no application-specific hot backup steps need to be performed.
Post Reply

Who is online

Users browsing this forum: No registered users and 96 guests