skater coder

Ok here’s the situation.

I’ve installed Sharepoint Server 2007 and SQL Server 2005 as a small farm on the same server with the intention of moving the SQL Server database to another server at another date. Unfortunately detaching all the databases and moving them to the new server and running the Sharepoint Configuration Wizard to try and connect to another server farm doesn’t quite do the trick.

Here’s how I eventually managed to move the content database from one server to another. It’s rather general, and from memory, but it should be enough to give you an idea of what to do.

1. Run “Sharepoint Products and Technologies Configuration Wizard” and disconnect from the server farm.
2. Run “Sharepoint Products and Technologies Configuration Wizard” again, and this time choose “create a new configuration database”, and key in the server name SQL Server database you wish move your content to. (I haven’t found a way to migrate the Sharepoint_Config and Sharepoint_AdminContent database files yet)
3. Click “Advanced” and select host admin site on this server.
4. After which, you should be able to access the “Sharepoint 3.0 Central Administration” site.
5. In Central Administration, create a new web application
6. Detach the WSS_Content database files from the source server, and copy to the target server.
7. Attach the WSS_Content database files on the new SQL Server 2005 server.
8. In Central Administration->Content Databases Delete the content data that was just created, and then add a new content database. Name this content database the same as the content_database file you just attached.
9. That’s it, you should be able to view the content you’ve just moved in the web application you created

Downsides, you won’t be able to move the sharepoint_config database, which means you will have to reconfigure your sharepoint installation again.

If you installed MOSS2007 and SQLServer 2005 on different servers and just want to move the database to another server, this article will show you how to do that.
http://blog.baeke.info/blog/_archives/2007/2/23/2759975.html