Backup the databases for the sites you want to upgrade.  Restore these backups as new databases on the SQL server in your WSS 3.0 farm.  Create web applications in WSS 3.0 for the sites that you are going to upgrade.  Remove the databases that are created with these web applications through WSS 3.0 central configuration.  Now attach the WSS 2.0 databases you just restored to SQL using stsadm -o addcontentdb to the web applications you created in WSS 3.0 for the migrated sites.  This is done through the command prompt.  To do this navigate c:program filescommon filesMicrosoft sharedweb server extensions12bin and type this command filling in the appropriate information.

stsadm.exe -o addcontentdb -url http://<server>:<port> -databasename <WSS v2.0 content database> -databaseserver <DB Server name>

for example

stsadm.exe -o addcontentdb -url http://MyServer:80 -databasename WSS_V2_ContentDB -databaseserver Sample

This will do an in place upgrade of the database.

Note:  If you SQL box has instances on it you will need to specify the instance the database is in for example <SQL Server Name><SQL Instance Name> in the <DB Server name> space above.

Related Articles and Posts

• Adding Google Gadgets to your Sharepoint site (1)

You Should Also Check Out This Post:

• Relieve Eye Strain and Fatigue with GUNNAR Optiks Glasses
• Beat the credit crunch making some extra money
• Easy Steps for Decision Making
• Secrets of success in 8 words, 3 minutes
• 5 Presentation Secrets That Will Change Your Life

More Active Posts:

• 5 Essential Steps Before Making a Presentation (4)
• Ten Ways To Start Taking Control (3)
• How to manage your time  (2)
• Secret of Successful Negotiation (2)
• Breaking a task into smaller pieces - WBS (Work Break Down) (2)
• Explore Office SharePoint Server 2007  (2)
• The Five Ps of Leadership (1)
• How to improve your soft skills at work (1)
• Test Your Negotiation Skills (1)
• How Music Affects The Human Brain (1)