none
DPM 2012 - Item-level recovery (ILR) of Hyper-V virtual machines. Does ILR support SQL level restore? RRS feed

  • Question

  • In http://technet.microsoft.com/en-us/library/hh757981.aspx ,

    DPM supports item-level recovery (ILR), which allows you to do a specific recovery of files, folders, volumes, and virtual hard disks (VHDs) from a host-level backup of Hyper-V virtual machines to a network share or a volume on a DPM protected server.

    I want to know whether DPM supports SQL level restore if a VM is running SQL server.

    Thanks!

    Monday, December 24, 2012 3:23 AM

All replies

  • Hi,

    Nothing prevents you from copying any set of files from the guest backup including SQL database files.  In theory, since a snapshot was taken in the guest to place the SQL databases in a consistent state, you should be able to copy them out and mount them.  With that said, I would run this by the SQL support guys in the SQL Server forum so you can get an official answer, then do some extensive testing.


    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, December 24, 2012 2:42 PM
    Moderator