Migrating from SQL 2008 Express to SQL 2008 R2 RRS feed

  • Question

  • Morning all,

    I've made the mistake of building a sharepoint 2010 sever and selecting the Stand alone installation.  Realising the errors of my ways I've setup another sp 2010 server as a farm, with SQL 2008 R2 Enterprise, but have no idea how to get the info from the stand alone server.

    Any help would be very much appreciated.


    Sunday, June 12, 2011 8:08 AM


  • Dear mpjubb,

    You have three solutions for this.

    1- Install SharePoint as standalone, then upgrade the database instance "<Your SQL Server>\SHAREPOINT" to SQL Server 2008 R2 Enterprise Edition.

    2- If you already now have SharePoint with farm installation, you can import your databases from "<Your SQL Server>\SHAREPOINT" to your SQL Server 2008 R2 Enterprise Edition, I mean of import is restore from backup or attach/deattach database.

    3- Also you can backup the farm or site or any part from SharePoint standalone and restore it or part from it through SharePoint farm installation.



    Ayman A. Barghouti

    • Proposed as answer by John P. WhiteMVP Monday, June 13, 2011 3:20 PM
    • Marked as answer by Seven M Friday, June 24, 2011 2:43 AM
    Sunday, June 12, 2011 2:36 PM