Wednesday, April 13, 2011

Upgrade WSS 2.0 (with MSDE DBs) to WSS 3.0

One of my friends was in process to upgrade his WSS 2.0 to WSS 3.0 but the main challenge was he was using WSS 2.0 with MSDE database so in place upgrade will not be helping him.
To achieve the goal we have followed below steps.

  • Copied all .mdf and .ldf files to new SQL server ( SQL 2005 )
  • Restored all DBs from .mdf and .ldf which had created new content DBs on SQL 2005 machine
  • Installed WSS 3.0 and connected it to SQL 2005
  • Created dummy sites and attached all the DBs using STSADM command - 

    stsadm -o addcontentdb -url URL NAME –dn DB NAME- one by one to sites and we got all our old sites up and running.

1 comment:

Web Development Company said...


This is Amazing information you are sharing.. Thanks

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.