Sign In

Backup and Restore a SharePoint Farm

Saru Ponnusamy Senior SharePoint Consultant
Jul 13, 2009

Did you ever need to backup and restore your content db on a new Farm? Here is how you do it:

  • On the database server for the current Farm, perform an offline backup of the content database. (Easiest way to accomplish this is to stop your SharePoint database service and copy the .mdf & .ldf files specific to the content db you want to move to)
  • Copy the .mdf & .ldf files for the content db to the SQL Data directory on the database server for the new Farm
  • Attach the copied database to the SQL instance on the new Farm
  • Open the SharePoint Central Administration on the new Farm
  • On the Application Management tab, create a new SharePoint Application. In doing so, specify the same port and host header info as in the original Farm
  • When the application creation process completes, do not run the Site Collection Creation Wizard
  • Within SharePoint Central Administration Application Management tab, click on Content Databases
  • Verify the Web Application and the content database is empty that was created during the Web Application creation process
  • On the Content Database Settings page, change the database status from Ready to Offline, and then select the option to Remove Content Database and click OK
  • Back on the Manage Content Databases page, click Add a content database
  • On the Add Content Database page, enter the name of the SQL server and the restored database name. Verify Windows Authentication is selected, select the appropriate Search Server, and click OK
  • Once this process is complete, return to the Manage Content Databases tab and verify if the restored content database is now associated with our new web application you just created
  • Run iisreset and ipconfig /flushdns from command prompt
  • Now, browse to your new web application and make sure everything works as expected

WebKMS Consultants Diary

On this Consultants Diary column, we share some of the problems we faced and how we solved for the benefit of our readers. We hope you find this real-world solutions useful and appreciate your interest and valuable feedback.

We update this column frequently, and encourage you to come back as often as you can.

We would also be glad to welcome if you have any specific request and we will try our best to post a solution on this column.

Doc collaboration Enterprise Intranet