Sunday, November 20, 2011

Move a Site Collection from one content DB to another

Here is how to move a site collection from one content database to another in SharePoint 2010 Powershell command prompt: http://technet.microsoft.com/en-us/library/cc825328.aspx To move all site collections in a content database to another content database, there is a command in the above link as well. NOTE: The SQL Server database properties must have enough space in the transaction logs. Setting Auto Shrink and Auto Close to True, and changing the growth of the transaction log file to auto grow and 10% increments or something, as well as changing the Transaction Recovery Model from Full to Simple, for the DESTINATION database, is probably a good idea or you will get an error that the transaction log is full or does not have enough room.

No comments: