locked
Migrate Farm from SQL 2000 to SQL 2005 RRS feed

  • Question

  • MOSS 2007:

    Hi,

    We have a small sharepoint farm in our company with an Application and a dtabase server running SQL Server 2000.

    We are planning to migrate the database to a different server running SQL 2005. I have gone through many forums and blogs and it has become very confusing. Some of them say, we have to run the Configuration wizard and to create a new server farm altogether. Some says, the SSPs have to be backed up and resotred differently.

    Has anybody faced the same situation and moved the databases (contnent, configuration, SSP) from SQL 2000 to SQL 2005 this way? Are these steps documented anywhere in MSDN or any other site?

     

    Thanks,

    Nayana



    • Edited by Mike Walsh FIN Wednesday, July 20, 2011 5:19 PM SLQ in title changed to SQL
    Wednesday, July 20, 2011 3:08 PM

Answers

  • Hi Nayana,

     

    There is a very good Technet article you can follow - make sure you follow the section "To move all databases to a database server that has a different name" there.

     

    Note there is a very confusing line "The new database server must use the same version of Windows Server and SQL Server as the old database server"in this article (NOT sure why)- just ignore that. I works fine otherwise - I myself tested this :-).

     

    Hope this helps!

     


    BlueSky2010
    Wednesday, July 20, 2011 5:26 PM

All replies

  • Hi Nayana,

     

    There is a very good Technet article you can follow - make sure you follow the section "To move all databases to a database server that has a different name" there.

     

    Note there is a very confusing line "The new database server must use the same version of Windows Server and SQL Server as the old database server"in this article (NOT sure why)- just ignore that. I works fine otherwise - I myself tested this :-).

     

    Hope this helps!

     


    BlueSky2010
    Wednesday, July 20, 2011 5:26 PM
  •  

    Edited byMike Walsh FIN<abbr class="affil">Microsoft Community Contributor</abbr><abbr class="affil">, Moderator</abbr>Wednesday, July 20, 2011 5:18 PMSharePoint 2007 - not needed in Title. MOSS 2007 added to text. Is it just a coincidence that you *and* Ireland both posted about migrating from SQL 2000 to SQL 2005 at almost the same time?

     

    Yes that was a coincidence that i thought curious myself!!  how many people have moss on sql 2000 and post at the exact same time when they want to move!! 

     

    Tuesday, July 26, 2011 10:07 AM