Move 1 site/DB from an existing IIS/SQL farm with multiple sites to a different existing farm with multiple sites
I have SITECOLLECTIONA that's part of a farm with several other sites. FARM1 is IISSERVER1, SQLSERVER1, INDEXSERVER1. There are other site collections within the farm that will not be moving. I need to move it to FARM2 is IISSERVER2, SQLSERVER2, INDEXSERVER2. This farm has a preexisting CA site and site collections. I need to move SITECOLLECTIONA from FARM1 to FARM2. Any suggestions? Thank you!
April 26th, 2010 11:22pm

You can do it with STSADM -export and STSADM -import. Start here: http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=26 If you don't mind installing some STSADM extensions, you'll find Gary LaPointe's extension very useful too. It's available here: http://stsadm.blogspot.com/2008/01/move-site-collection.html I trust that answers your question... Thanks C http://www.cjvandyk.com/blog
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2010 11:48pm

I appreciate it but I'm not really following. http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=26 looks like I'm moving sites around on the same server, which isn't the case here. The stsadm gl-movesite looks promising, but I'm not sure this will do what I need either, to move a site collection from a DEV IIS/DB/Index to a PRODUCTION IIS/DB/Index.
April 27th, 2010 8:14pm

three things you need to do at a minimum: Backup: Stsadm Migrateuser: Stsadm Restore: Stsadm Kanwal SharePoint Buzz
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2010 8:35pm

Hi, You can do it at the SQL/STSADM level. I prefer this, as it isn't nearly as inclined to fail and leaves you with more flexibility. 1) Find the content Database,These are listed under Central Admin->Application Management->Site Collection List 2) Backup the content database,You could alternatively detach it, and copy it. Just doing a backup in SQL Server Management studio is easier. 3) Restore content database to the production SQL server Copy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db). 4) Create Web App on new Server Central Admin->Application Management->Create or extend Web App->Create New Web App. 5) Associate restored DB with new Web App Central Admin->Application Management->SharePoint Web Application Management->Content Databases-> Remove Content Database from your new web app. Now use STSADM to add restored DB to this web app c:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM. run this command from there. stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver 6) Run ISSRESET from command promptBest Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
April 27th, 2010 8:42pm

Thanks so much guys. I'm going to give 'em a try and report back. update: Thanks all, and especially Ahmed.Ammar. The guidance is much appreciated. Followed the steps and worked.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2010 9:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics