none
Exclude SQL databases from DPM image level backup? RRS feed

  • Question

  • 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

    Tuesday, September 16, 2014 7:20 AM

All replies

  • 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.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, September 16, 2014 10:10 AM
    Moderator
  • 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

    Friday, September 19, 2014 6:33 AM
  • 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.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, September 19, 2014 6:48 AM
    Moderator
  • 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

    Friday, September 19, 2014 7:24 AM
  • 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

    Wednesday, June 24, 2015 11:49 AM
  • 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.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, June 24, 2015 11:57 AM
    Moderator
  • Hi again,

    It looks like it still take's vss backups of the sql server even though I have the registry entry. Any more idees? 

    Regards

    Roger

    Tuesday, November 24, 2015 12:49 PM
  • Tuesday, November 24, 2015 4:47 PM
    Moderator
  • The issue is that the Windows team made enhancements in Windows 2012 and this registry check was removed in Server 2012 R2, so it is no longer honored.

    In Server 2012 they introduced a cleaner way to achieve the same thing by adding provisions for a VSS requester (in the host) to control the back type in the guest, using IVssBackupComponents::SetBackupOptions API.   This new method is not implemented in DPM 2012 R2.

    The easy workaround is to deselect "Backup (Volume Checkpoint)" option in the VM properties under integration Services.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, December 1, 2015 12:43 AM
    Moderator