Move all SharePoint 2010 databses to new SQL server WITHOUT USING A SQL ALIAS RRS feed

  • Question

  • Hi Guys,

    Current environment: SQL Server (DB04), SharePoint 2010 servers (AP01, FE01) using SQL Alias 'DB06' pointing to DB04

    Due an in place upgrade of MOSS 2007 to 2010 which was then moved to new hardware a SQL alias using the old server name (DB06) was created, this allows the new SQL Server (DB04) to be used.

    I would like to rename the SQL Alias to to something more sensible as it's confusing the support staff.

    Is there a walkthough/Technet article describing to to rename the dabatase server for all SharePoint DBs? Is it even possible? I know the content DB server can be changed easily but what about the service application and config DB etc?



    Monday, September 24, 2012 3:47 PM


All replies