Move FCI Analisys Services

• crcoracle

  Right there with Babe

  Points: 778

  More actions

  December 19, 2017 at 1:58 pm

  #330547

  Hi,
  I have a FCI installation with SQL 2016 (Database and Analisys Services) in two node cluster. First node is the active, and the another is the standby.
  I'd like to create a new failover role on the standby node and move Analisys Services from the main role to this new role.

  Currently:
  First Node-> FCI role with DB and AS
  Second Node-> Nothing

  What I want:
  First Node-> FCI role with DB
  Second Node-> FCI role with AS

  I guess a  should install a new FCI installation of AS and drop the first one, isn't it? Should I take something more into account? What are the steps to do this?

• Evgeny Garaev

  SSCertifiable

  Points: 7428

  More actions

  December 19, 2017 at 7:01 pm

  #1972830

  Check this document - http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SSAS_Failover_Cluster_V4.docx