Host-based backup of Microsoft Hyper-V VMs.
Post Reply
bathi
Novice
Posts: 4
Liked: never
Joined: Feb 08, 2018 9:58 am
Contact:

Creating .avhdx in another folder?

Post by bathi »

Hi,
It seems like an .avhdx file gets created eachtime a backup is taken.
So I got this VM with two hard drives, the first drive I guess is no problem, its on a das, but the second one is a physical SSD with only 185GB. It gets filled up pretty fast when the .avhdx file is created and then the VM get set on pause.
Is it possible to create those .avhdx somewhere else and not on the drive where .vhdx lies?
Its a SQL server so it gets pretty problematic if it stops :lol:
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Creating .avhdx in another folder?

Post by Mike Resseler » 1 person likes this post

Hi bathi,

First: Welcome to the forums

The .avhdx is the differencing file that is created when you make a snap shot. You cannot change the location of that avhdx because it needs to be in the same location as the VHDX file.

Cheers
Mike
bathi
Novice
Posts: 4
Liked: never
Joined: Feb 08, 2018 9:58 am
Contact:

Re: Creating .avhdx in another folder?

Post by bathi »

Hehe, thank you :)

Do you approximately know how much the .avhdx filesize is, if the .vhdx is set to 180GB?

It probably depends?
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Creating .avhdx in another folder?

Post by Mike Resseler »

Yes it depends.

When you take a snapshot, the VHDX is made read-only and all writes are redirected to the created AVHDX. This is standard for Hyper-V, nothing we can do about it. After that the backup has been processed, we tell Hyper-V to go ahead and release the snapshot. At that moment the VHDX becomes read/write again and all of the differences that are recorded in the AVHDX are being merged into the VHDX (and then the AVHDX disappears). So depending on how long the backup takes, and how much data is being changed/ written during that time, the size can be small till very large.

Maybe a small idea, but seeing your concern is about a SQL server (and if it is an active one, that could mean a lot of changes quickly...) I would suggest to try to schedule the backup during a period where the SQL does not have much to do. Outside the business hours and outside the moments it does BI or maintenance jobs or similar

Hope it helps
Mike
bathi
Novice
Posts: 4
Liked: never
Joined: Feb 08, 2018 9:58 am
Contact:

Re: Creating .avhdx in another folder?

Post by bathi »

Ok, I see.

Is it possible to turn off snapshots while taking backup, or does it have to stay at a read only state to be able to take backup of?
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Creating .avhdx in another folder?

Post by Mike Resseler »

It is not possible. You need to have those snapshots or you might end up with data corruption
bathi
Novice
Posts: 4
Liked: never
Joined: Feb 08, 2018 9:58 am
Contact:

Re: Creating .avhdx in another folder?

Post by bathi »

Ok, thanks again! :)
Rumple
Service Provider
Posts: 81
Liked: 14 times
Joined: Mar 10, 2010 7:50 pm
Full Name: Mark Hodges
Contact:

Re: Creating .avhdx in another folder?

Post by Rumple »

it is totally possible...but not recommended...you can disable the hyperv integration which will do a crash consistent copy of the VM (aka, no snapshot) and then implement the application consistency so that it truncates logs and marks the databases as backed up.
SQL is actually pretty good at recovering itself most times from a crash (which is what it would look like), but if you have a 3rd party product doing real SQL backups then the risk is pretty minimal...schedule sql backups 30 minutes before the VMM snapshot and you have a pretty good recovery strategy without the risk from the snapshot files taking down the system...
Post Reply

Who is online

Users browsing this forum: No registered users and 26 guests