none
Can you skip SQL backup when using DPM 2012 on a Hyper-V VM? RRS feed

  • Question

  • This may sound like a strange question.  I'm using DPM 2012 to backup a SQL database server.   The SQL admin doesn't want it taking SQL backups.  Is there any way to have it take the image but not interact with SQL?  (yes, I realize the databases would have to be restored after the image was restored)
    Monday, April 29, 2013 9:03 PM

All replies

  • Hi,

    In other words, you don't want a host level backup of a SQL Server guest to truncate SQL Db logs.  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.

    975354  A Hyper-V update rollup is available for Windows Server 2008 R2
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;975354

    See Issue 3

    The application backup operation in the virtual machine (VM) is incorrectly affected by the VM backup operation on the server that is running Hyper-V.

     

    Note You may still experience issue 3 after you install this hotfix. You can apply the following registry entry in a virtual machine to fix issue 3 for that virtual machine:

    Location: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Virtualization\VssRequestor
    Name: BackupType
    Type: REG_DWORD
    Value: 0 or 1

    If this registry entry is created and its value is set to 1 , application backup will not be affected by the virtual machine backup operation on the server that is running Hyper-V. If this registry entry does not exist, or if its value is 0 , issue 3 occurs.


    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.

    Monday, April 29, 2013 11:34 PM
    Moderator
  • Yes, that sounds like it is probably what I need.   Thanks!

    I'll give that a try and see how it goes.

    Tuesday, April 30, 2013 12:18 PM