locked
Upgrading from sharepoint 2.0 RRS feed

  • Question

  • I know it's a shame !
    we are finally going to upgrade sharepoint 2.0 to 3.0 , unfortunatly  gradual upfgrade option is not available (because we use MSDE database) . what is the proper method of backup and restore for sharepoint 2.0 ? I don't want to take any risks by running in-place upgrade. atleast need to be sure about a
    proper recovery option....

    I googled this but couldn't find a 100% solution. Please reply if you have done this before.
    Thursday, March 24, 2011 7:43 PM

Answers

  • Hi Ali,

    You have to first copy all your mdf and ldf files to new SQL server by stopping running SQL instance.

    Then restore all DBs frm LDF and MDF to new SQL which will make DB folders on new SQL (use SQL server Management Studio)

    Install SharePoint and connect it to new SQL server.

    Once your SharePoint central admin will be up and running , start creating sites and use following command to attach content DB.

    before attaching content db detach existing one.

    stsadm -o addcontentdb -url <Site URL> -dn <Database name>

    This will make your WSS 2.0 site running on WSS 3.0

    hth


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Emir Liu Thursday, March 31, 2011 10:48 AM
    Friday, March 25, 2011 9:52 AM

All replies

  • Hi Ali,

    You have to first copy all your mdf and ldf files to new SQL server by stopping running SQL instance.

    Then restore all DBs frm LDF and MDF to new SQL which will make DB folders on new SQL (use SQL server Management Studio)

    Install SharePoint and connect it to new SQL server.

    Once your SharePoint central admin will be up and running , start creating sites and use following command to attach content DB.

    before attaching content db detach existing one.

    stsadm -o addcontentdb -url <Site URL> -dn <Database name>

    This will make your WSS 2.0 site running on WSS 3.0

    hth


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Emir Liu Thursday, March 31, 2011 10:48 AM
    Friday, March 25, 2011 9:52 AM
  • Hi Patrik

    ou are offering an alternative upgrade path rathre than in-place upgrade, we are currentlu using sharepoint 2.0 on MSDE . it's not SQL . If I just backup the database and restore it on 3.0 , does it work ? I thouht database also needs to be upgraded to be compatible with version 3.0.
    Friday, March 25, 2011 4:36 PM
  • Hi Ali,

    in MSDE database do you have .mdf and .ldf files associated with Database name ?

    If yes just copy it and put it on the new SQL machine and then follow above mentioned procedure.


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Friday, March 25, 2011 4:39 PM
  • Yes , we do.

    So this means that by running stsadm command we resstore the database and it will be sharepoint 3.0 compatible..., right ?
    Friday, March 25, 2011 8:15 PM
  • Hi Ali,

    Yes it will work.


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Saturday, March 26, 2011 6:08 PM
  • Thanks . I was able to do a successful migration . thanks for all helps and advises.
    Thursday, March 31, 2011 5:37 PM