If you have installed SharePoint (SP0) and you want to move a content database to a deployment running SP1 without upgrading the whole farm, read on!
First off, create a blank team site (Central Administration > Application Management > Create or extend Web application) and then follow the steps below.
When you attempt to attach the database through the central admin web interface, you might get hit with the following error:
Attaching this database requires upgrade, which could time out the browser session. You must use the STSADM command 'addcontentdb' to attach this database.
To get around this, do what the error says...
- RDP to your SharePoint server
- Open the Command Prompt (Start > Run >CMD)
- Paste the following line into the prompt "cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\bin", this will take you to the 12 Hive
- Type the following command:
stsadm -o addcontentdb -url http://SiteName -databasename WSS_Content_DATABASENAME -databaseserver DOMAIN\DATABASESERVER
- Hit enter, and all going to plan you will get: Operation completed successfully
To make sure, go to Central Administration > Application Management > Content Databases and it should be there. Take the origional database (the one created when you created the site) offline and make sure this one is the only one online. Navigate to your site and again, make sure it is all there!