SCCM restore SQL 2005 to SQL 2008


  • We're migrating our SCCM 2007 SP2 R3 Central Site server to new hardware.

    On the old server, SQL 2005 is installed and on the new hardware, we have installed SQL 2008 R2.

    Is it supported to run SCCM Repairwizard and restore a SCCM site backup that was originally SQL 2005, to a server with SQL 2008 R2 database?

    The new server has the exact same name and ip-adress as the old server. Also, the old server had Windows server 2008 x64 installed, the new one has 2008 R2.

    Thanks /Paul


    2011년 11월 8일 화요일 오후 2:48


모든 응답

  • Yes, that should work.
    Torsten Meringer |
    2011년 11월 8일 화요일 오후 3:39
  • Just be aware of the collation order, it needs to match otherwise you will get problems.
    Kent Agerlund | My blogs: and | Twitter @Agerlund | Linkedin: /kentagerlund
    2011년 11월 8일 화요일 오후 9:05
  • Just to add to Kent's comment, it is the collation of the server, no just the CM07 database.
    2011년 11월 14일 월요일 오전 2:49