CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • SQL Server Management Studio Always On Availability Group Change Primary Listener

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    4248
  • Date Created
    Thursday, May 5, 2022
  • Last Updated
    Thursday, May 5, 2022
  • This Article Has been Viewed
    484 times
  • Short Desc
    This article will show you how to change the Primary Listener in SQL Server Management Studios Always On Availability Group.
  • Details
    This article will show how to perform a failover within the Always On Availability Group (AOAG). This is required with performing maintenance or if a SQL Server instance is having an issue, and you want to take it offline before it causes significant problems without your AOAG.
  • Recreate Issue
    In our network, we have a maintenance server that we failover too when we take down our primary server, a [Dell r710]. The maintenance server's SQL Server instance is a part of the SQL Server AOAG. Since this SQL Server is a part of the AOAG, we can stay online without showing a maintenance banner in place of our websites.
    The maintenance server has nowhere near the power of the [Dell r710]; it does the job we need to stay online while making our servers better for our future.
  • Resolve Issue
    The built-in Wizard to failover to a new SQL Server primary is more straightforward than the standard method.

    The method described below allows for a quicker and simpler failover transition.

    In SSMS, expand the SQL Server Listener Server. Example: [MyAOAGListener,2433]
    Right-click [Always On High Availability]
    Choose [Show dashboard]
    When the Dashboard opens, on the top list of [Availability replica:]
    Click on the SQL Server Instance to failover too.
    Once the page opens, from the top left side.
    Choose [Start Failover Wizard]
    This method will only have the chosen server selected and available for the failover.
    Follow the wizard to failover the chosen SQL Server instance.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles