Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SharePoint 2010 site on a test server and database. I would like to move my site to a production server and a new SQL instance. What is the best way to do this?

Was really easy, here are the PowerShell commands for exporting and importing.

Export-SPWeb -Identity http://OLDSITE/ -Path \\SERVER\backup\sharepoint\SiteExport.cmp -IncludeUserSecurity -IncludeVersions All -Verbose

Import-SPWeb -Identity http://NEWSITE/ -Path \\SERVER\backup\sharepoint\SiteExport.cmp -Verbose -Force
share|improve this question
up vote 1 down vote accepted

Unless you installed sharepoint using a SQL Alias you will need to create a DNS alias/host file with the old name of the SQL server that points to the new one, and the instance name will need to be the same.

  • Stop SharePoint
  • Backup the databases on the old database server
  • add logins to the new server with sysadmin rights
  • script out SharePoint jobs from old database server
  • rename old database server
  • create DNS alias that point old database server name to the new database server name
  • restore database backups to the new database server
  • run job script on new database server
  • restart SharePoint after a ping resolves the old name to the new server (use ipconfig /flushdns to force update)
share|improve this answer
Edited question to include solution. – Relentim Jul 22 '10 at 13:43
Thanks for the answer anyway! – Jason Cumberland Jul 22 '10 at 18:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.