I am trying to move an existing Site Collection from one content database to a new content database in Microsoft Office SharePoint Server 2008 with Windows SharePoint Service 3.0. The site collection move is on the same server, which is where the complication from the instructions I've read so far, which seem to be focussed on moving or duplicating a site collection to a new website application, on a different production or testing server, but not from one site collection to another site collection on the same production server.
Here are links to what I've followed or done so far.
I've done the following: Using stsadm.exe I've backed up the site collection to a database file. I've then duplicated the Content Database in SQL Management Studio. I've then created the new Website Application and created a blank Site collection to where I want to move the site collection. I've tried "restore" with stsadmin (http://technet.microsoft.com/en-us/library/cc262087.aspx
) to this new site collection:but that didn't work. I then tried removing the new Content Database from the new site collection and then added the duplicated content database in SQL to this new site collection using stsadm with -addcontentdb, which completes successfully, but shows "0" for the number of sites in the site collection, when it should appear as 6, when comparing it to the original Site collection and it's content database.
Any instructions on what I need to do to duplicate the site collection to a new website application and content database would be HUGE right now. I've been trying this for 2 days now with no success and I need help.