Migrating WSS 3.0 intranet or internet to Sharepoint 2007

Step 1 : BACKUP Backup Database for Site 80 of WSS 3.0. Do below steps on WSS 3.0 server ( SESIS01.domain.com).How to find which database need to take backup for Sharepoint 80? See below

Database name is WSS_Content and copy from below location

Step 2 : RESTORE
· Install fresh Sharepoint Portal Server 2007 on Windows 2008
· After installation copy the database backup to the server running Sharepoint 2007
· Restore the database backup onto the SQL server 2008 – SESOP04.
· Open the Sharepoint 3.0 Central Administration site. This can be located at Start->Administrative Tools->Sharepoint 3.0 Central Administration.
· Click on the Application Management tab at the top of the screen
· Go to "Create or extend Web Application" under the "Sharepoint Web Application Management" section.
· Click on "Create a new Web application" to create the new Web Application where we are going to restore our Sharepoint 2003/WSS V2.0 site to.
· Fill in the appropriate information to create a Sharepoint 2007/WSS V3.0 Web Application in your environment and click "OK"
· Once the "Operation in Progress" screen has disappeared and the create operation is completed you will be taken to the "Application Created" screen. Do not go to "Create Site Collection".
· Open a command prompt.
· Run the Sharepoint stsadm tool with the following command line:

stsdm -o addcontentdb -url http://sesop05/ -databasename wss_content -databaseserver sesop04
NOTE: We need to use the stsadm command line tool to add the new content database because the web application may timeout if you use it to add the content database.

· Click "Enter" and the content database will be added to the site.
· Return to the Sharepoint 3.0 Central Administration application and click on the "Application Management" tab.
· Click on the "Content databases" link under the "Sharepoint Web Application Management"
· You will be redirected back to the "Content databases" screen
· Make sure that the Web Application you just created is selected in the drop-down list of Web Applications.
· Click on the content database that was initially created when you created the web application.
· On the screen that appears click the check box next to "Remove content database".
· Click "OK". This will remove the initial database from the SQL Server.
· Your site is not ready to access. However if you are moving to a machine that has different user accounts you may have a problem logging into the new site. If you do follow the rest of the steps in the article.
· Go to the "Application Management" tab in the Sharepoint 3.0 Central Administration application.
· Click on "Site Collection Owners" located under "Sharepoint Site Management"
· Make sure the correct Web Application is selected in the drop-down
· Set the Primary and Secondary site collection owners to the correct user accounts and click "OK"
· Your site will now be ready to access with primary or secondary site collection owner account.