I have a SQL 2008 server I need to migrate the SharePoint databases to a new SQl 2008r2 server. Not heavily used, I believe I want to do the following:

1.Shutdown SharePoint
2.backup the databases
3.restore databases and appropriate logins to new server

Then what do I do to point SharePoint to new backend (sorry this question is coming from dba).


Once you moved the database new server after that if you use SQL Alias...

  • Refer the farm to the new database server by creating a SQL Server connection alias.

If you are using the DNS alias then you just need to update DNS alias. After that start your SharePoint.

Read the Technet for more details, how to create alias etc

Move all databases (Office SharePoint Server 2007)

Check my response over here...Can I migrate Sharepoint 2010 databases from a SQL 2008R2 server to SQL 2012 server?

  • thought that would work, however will the alias cause an issue for existing databases on the server I am moving to? – tcroninstl Sep 11 '14 at 19:19
  • what issue with exisitng database server? – Waqas Sarwar MVP Sep 11 '14 at 19:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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