locked
Move/Migrate WSS 3.0 DBs from SQL 2005 to 2008R2 RRS feed

  • Question

  • Looking for a little insight here.  I have WSS 3.0 SP2 running on Windows Server 2008, and my WSS databases on a remote server running Windows Server 2003 R2 with SQL 2005.  The problem is my database server is being retired, and we're wanting to move the databases, users, permissions, etc on to our new db server running Windows Server 2008R2 and SQL 2008R2.  Is this even possible?  I've seen some documentation that states moving DB's to a new server requires the same OS and SQL version, I've seen other documentation that states it's no big deal and is easy to do.  So, is this possible?  Is it a good idea?  If yes to both, is there a procedure somewhere that dictates EXACTLY how to do this?  If this isn't possible, what's the best way of accomplishing my goal without have to completely redo WSS and all my sites.

     

    Thanks,

    Tim


    Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
    My Blog Site: http://tmagnuson.wordpress.com
    Thursday, January 27, 2011 7:19 PM

Answers

  • Hi,

    As per my knowledge its not required to have same OS and same SQL version.

    As you are going to migrate over SQL 2008 R2, it will work. Older versions can work on newer but newer can't on older.

    The best way is to take DB backup first

    • Disconnect WSS farm from SQL 2005 server
    • Move all DB files (.mdf & .ldf) to new server
    • Restore those files on SQL 2008
    • Run PSConfig to join WSS to SQL 2008.
    • Once you will get Central admin up and running you can create sites one by one with temp DBs 
    • Detach temp DB and attach original DB which you will move from SQL 2005 server.
    • This will make your site work again as it was working with SQL 2005.

    In addition I would like to add, if you will create a new configuration DB on SQL 2008 you have to manually redeploy all your customization.

    hope this helps

     


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Leoyi Sun Tuesday, February 8, 2011 9:38 AM
    Thursday, January 27, 2011 7:51 PM
  • Yes that's right.

    PSConfig = SharePoint Products and Technology Configuration Wizard


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Leoyi Sun Tuesday, February 8, 2011 9:38 AM
    Thursday, January 27, 2011 8:44 PM

All replies

  • Hi,

    As per my knowledge its not required to have same OS and same SQL version.

    As you are going to migrate over SQL 2008 R2, it will work. Older versions can work on newer but newer can't on older.

    The best way is to take DB backup first

    • Disconnect WSS farm from SQL 2005 server
    • Move all DB files (.mdf & .ldf) to new server
    • Restore those files on SQL 2008
    • Run PSConfig to join WSS to SQL 2008.
    • Once you will get Central admin up and running you can create sites one by one with temp DBs 
    • Detach temp DB and attach original DB which you will move from SQL 2005 server.
    • This will make your site work again as it was working with SQL 2005.

    In addition I would like to add, if you will create a new configuration DB on SQL 2008 you have to manually redeploy all your customization.

    hope this helps

     


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Leoyi Sun Tuesday, February 8, 2011 9:38 AM
    Thursday, January 27, 2011 7:51 PM
  • Pratik,

    Thanks for the quick answer!  Let me ask you this.  Since my server that's hosting WSS isn't changing, can I take a full backup of the farm, and then do a farm restore  by selecting a new configuration, keeping all my settings the same but specifying the new sql server name in all the db fields?  Or would this destroy my farm doing it that way?  The big thing is keeping all my content like lists, pages, and whatever user content has been published.

     

    Thanks

    Tim


    Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
    My Blog Site: http://tmagnuson.wordpress.com
    Thursday, January 27, 2011 8:16 PM
  • That should be work all your pages . lists and content expect customization.

    AS I have mentioned earlier new configuration DB requires redeployment of customization , you can use existing Config DB as well but most of the time I have seen it will create lots of issues in future, so I always suggest to create a new config DB.


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Thursday, January 27, 2011 8:25 PM
  • Excellent!  Thank you for your help.  I will post back here if I run into any problems.

     

    Thanks

    Tim


    Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
    My Blog Site: http://tmagnuson.wordpress.com
    Thursday, January 27, 2011 8:37 PM
  • Hi,

    As per my knowledge its not required to have same OS and same SQL version.

    As you are going to migrate over SQL 2008 R2, it will work. Older versions can work on newer but newer can't on older.

    The best way is to take DB backup first

    • Run PSConfig to join WSS to SQL 2008.

     


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

    One point of clarification, I think you mean run the Sharepoint config wizard correct?  Otherwise I don't know what PSConfig is.

     

    Thanks!


    Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
    My Blog Site: http://tmagnuson.wordpress.com
    Thursday, January 27, 2011 8:38 PM
  • Yes that's right.

    PSConfig = SharePoint Products and Technology Configuration Wizard


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Leoyi Sun Tuesday, February 8, 2011 9:38 AM
    Thursday, January 27, 2011 8:44 PM