none
SC 2012 DPM - Setting Up the SQL Server for the Disaster Recovery RRS feed

  • Question

  • Hello All,

    There is a VM with Windows 2008 R2 SP1 Server which has SQL Server 2008 R2 running on it.

    The VM has 2 VHD disks:

    • Disk 0 has:
      System Reserved - 100 MB - Healthy (System, Active, Primary Partition)
      Drive C: 31.9 GB - Healthy (Boot, Page File, Crash Dump, Primary Partition)
      OS is installed on disk C:
    • Disk 1 has:
      Drive D: 32 GB - Healthy (Primary Partition)
      SQL is installed on disk D:

    How to set up the SC 2012 DPM for the protection of that VM so in case of the disaster recovery it would require the least amount of time for its restoration?

    Thursday, September 6, 2012 12:14 AM

Answers

  • Why would you need a separate SQL Installation? You mean to host DPM database?

    That wouldn't be necessary as DPM installs its own SQL Express and the performance are not that bad using that solution. You don't need to configure anything using that solution.

    You can protect the VM and then you will only have to restore them in case of crash.

    If you want you can also protect the Hyper-V using BMR protection. To restore BMR you will need the OS installation media and a backup (http://blogs.technet.com/b/dpm/archive/2010/05/12/performing-a-bare-metal-restore-with-dpm-2010.aspx)

    • Marked as answer by mike33km Friday, September 7, 2012 7:33 PM
    Thursday, September 6, 2012 11:14 PM

All replies

  • Hi,

    you should perform Hyper-V backup added to the SQL Protection.

    Hyper-V could be done once a day if your SQL or Windows configuration doesn't change often.


    Restore the Hyper-V guest first then restore the SQL Data.

    Thursday, September 6, 2012 8:52 AM
  • Thank you for the information Jérémy!

    Would you be so kind to elaborate on the following items:

      • Does your recommendation require a separate fresh SQL installation?
      • How to determine which SQL services/components require to be installed?
      • Is there a way to setup a SQL bare metal installation so the only things which are necessary is freshly built VM with VHDs, Windows OS installation DVD and a backup? If so, then how to perform that?
    Thursday, September 6, 2012 2:40 PM
  • Why would you need a separate SQL Installation? You mean to host DPM database?

    That wouldn't be necessary as DPM installs its own SQL Express and the performance are not that bad using that solution. You don't need to configure anything using that solution.

    You can protect the VM and then you will only have to restore them in case of crash.

    If you want you can also protect the Hyper-V using BMR protection. To restore BMR you will need the OS installation media and a backup (http://blogs.technet.com/b/dpm/archive/2010/05/12/performing-a-bare-metal-restore-with-dpm-2010.aspx)

    • Marked as answer by mike33km Friday, September 7, 2012 7:33 PM
    Thursday, September 6, 2012 11:14 PM