migrating sharepoint databases

Posted by Alex Bransky on Geeks with Blogs See other posts from Geeks with Blogs or by Alex Bransky
Published on Wed, 16 Feb 2011 22:55:44 GMT Indexed on 2011/02/16 23:26 UTC
Read the original article Hit count: 218

Filed under:

If you're wondering how to migrate your SharePoint databases to a new server, this Microsoft article is actually pretty useful, though still overly complex like most of their other articles.

http://technet.microsoft.com/en-us/library/cc512725.aspx

The one thing I would change is that they seem to recommend installing SQL Server Configuration Manager on web servers, when all that was needed in my case was to add an entry to the hosts file on the SharePoint web server that used the IP address of the new SQL Server with the name of the old SQL Server.  This might not be appropriate in cases where the old server is not being decommissioned.

 

© Geeks with Blogs or respective owner