Home / server / Questions / 161879
Accepted
Relentim
Asked: 2010-07-20 08:11:37 +0800 CST

How do I migrate a SharePoint 2010 site to a new server and new SQL instance

  • 772

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
sql-server migration sharepoint sharepoint-2010

1 Answers

  1. Best Answer

    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)
    • 1