Move ALL Sharepoint databases to new SQL High-Availability Cluster RRS feed

  • Question

  • The DB server for our current SP2010 environment is being moved to a high-availability SQL cluster.  It will be a new named instance on the cluster.  I will be following the steps to do this in this article ... http://technet.microsoft.com/en-us/library/cc512725.aspx.

    In the article it states that 'you have to create a SQL Server connection alias on all web servers and application servers in the farm' to point to the new server.  Is there another option?  Is there not a powershell command that I could run to actually change the db server name reference within Sharepoint instead of creating the connection alias?

    Just asking.

    Sunday, January 30, 2011 6:41 PM


  • You should be using a SQL alias anyway.  if you had started with a SQL alias in your original install you could move the existing databases to a new server and instance just by changing the alias.  At this point you culd change the dB server name for the content databases, but not for the config database.  That's why they recommend using an alias.
    Paul Stork SharePoint Server MVP
    • Marked as answer by Joanne K Sunday, January 30, 2011 10:52 PM
    Sunday, January 30, 2011 9:02 PM