Moving SharePoint content databases to another installation

Steps I followed to move my SharePoint (WSS v3) Content Databases to SharePoint 2010 on another server (including upgrade) were:-

  1. Detach DB from SQL2008 on original server using SQL Management Studio.
  2. Copy the .mdf and .ldf files for the content database to the DB folder on the new server.
  3. Attach DB to new SQL 2008 R2 server using SQL Management Studio.
  4. Create web application in SharePoint 2010 Central Administration using the same URL as the original site (must be exact name).
  5. After the site has been created successfully, delete its default content database from SharePoint Central Administration.
  6. Copy the SSL certificate (including private key) from the original server to the new server and import into the Certificates/Local Computer store.
  7. Configure the IIS Bindings (IP Address, SSL, Host Headers, Ports) for the new SharePoint web site.
  8. Run the powershell command from the SharePoint Management Shell to attach the DB to the web application in SharePoint 2010. This process also upgrades the database. ( Mount-SPContentDatabase -Name STS_<name>_848357356 -DatabaseServer <servername> -WebApplication https://sp.<domain>.com/ -Updateuserexperience )
  9. Configure the correct Alternate Access Mappings (AAM) for the site in SharePoint Central Administration.
  10. Change the Web Publishing Rule on the TMG server to point to the new SharePoint server.

That’s it!

This entry was posted in Microsoft Server. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>