SQL 2008 SP2 is now supported as DPM 2010 backend RRS feed

  • General discussion

  • The SQL backend for DPM 2010 server can now be on SQL 2008 SP2 version. If you have a remote SQL backend, it can also be upgraded to SQL 2008 SP2. Both the configurations are fully supported.

    Thanks Praveen T [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, February 9, 2011 11:27 AM

All replies

  • Hi Praveen,

    Please can you give some more information about the if DPM 2010 is working with a remote instance of SQL 2008 R2.  I still find only info that the setup is not working wiht SQL 2008 R2.

    Can you explain how this must be done?
    Currently I am in an migration of DPM 2007 (on Win 2008, x64) with a remote instance of SQL 2005.  We want to upgrade (= same machine) to DPM 2010 (on Win 2008 R2, x64) with a SQL 2008 R2 remote instance (we do not have have SQL Server 2008 in house, only 2008 R2).
    My upgrade path is the following:
      1. DPM 2007: change remote instance to local instance
      2. Upgrade DPM: Upgrade DPM 2007 with local instance to DPM 2010 with local instance
      3. upgrade Windows: Upgrade Windows Server 2008 to Windows Server 2008 R2
      4. upgrade SQL Instance:  When hotfix is avalailbe upgrade SQL 2008 local instance to SQL 2008 remote instance

    If SQL 2008 R2 as remobe/local instance is already supported, it saves me a lot of effort and time



    Monday, April 11, 2011 10:50 AM
  • Good to hear that Praveen. Should DPM 2010 Server require any hotfixes/rollups to support SQL 2008 SP2 as backend? To be precise should the DPM Server be any better than version 3.0.7696.0?
    Thursday, February 2, 2012 4:34 AM