Hello,

Is it possible to make DPM exclude SQL database backups when backing up the vhdx?

We currently use Ola Hallengren scrip for backup and are planning to continue using this since the developers do alot of backup and restores and don't have to be dependent on the IT guy when asking for a restore ( the developers and IT infrastuctur guys work on different companys.... ).

I still want to make image level backup and not file backups.

Regards

Roger

HI,

If the Hyper-V server is 2008 R2 based, you need this fix, then apply the registry key in the guest, if Windows 2012 based, just add the key in the guest.

975925 A hotfix is available that addresses the issues that occur when you perform a host-level backup of a Hyper-V VM on a computer that is running Windows Server 2008
http://support.microsoft.com/kb/975925/en-us

When you perform a host-level backup of a Hyper-V virtual machine (VM) on a computer that is running Windows Server 2008, you may experience one of the following issues.

See Issue 1

Consider the following additional conditions:The VM is running Microsoft Exchange Server or a transactional application.

A backup application is running on the VM.

The backup application is configured to back up Exchange Server or the transactional application.
When the host-level backup of the VM is completed, the transaction logs for Exchange Server or for the transactional application are deleted. Therefore, the backup application cannot back up Exchange Server or the transactional application.

1. In Registry Editor, locate the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Virtualization\VssRequestor

2. Create a registry entry of the REG_DWORD type.
3. Set the name of the registry entry to BackupType.
4. Set the value of the registry entry to 1.

Hello,

Thanks for the answer!

Does this mean that I can't do ITL recovery on the VM?, or does this just exclude database backups?

Regards

Roger

Hi,

The registry tell hyper-V writer not to invoke application writers inside the guest when a host level backup is initiated.  This means that instead of the SQL databases being in a consistent state after the guest is backed up, the databases will be in a crash consistent state, so you may need to restore the SQL database using the Ola Hallengren script after restoring a VM from DPM backup to restore a verified good sql backup.

I noticed that i was missing the Virtualization folder in the Registry on one of our three SQL Servers. Where does the Virtualization folder come from?

Regards

Roger

Hi again,

I'm missing the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Virtualization\VssRequestor container.

I only have HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ and not the virtualization container. Should I create both the Virtualization and VssRequestor container?

Regards

Hi,

Yes, make the keys and values as needed.  If that does not work then I can move this thread to the windows hyper-v forum.