Post reply

Disaster Recovery and High Availability Solutions in SQL Server

  • April 15, 2024 at 12:00 am

    #4397519

    Comments posted to this topic are about the item Disaster Recovery and High Availability Solutions in SQL Server

  • April 17, 2024 at 8:25 pm

    #4412530

    It would have been helpful to know what prerequisites are required for a command to run successfully. For example,

    -- Run this on each server instance participating in the AG.
    EXEC sp_configure 'hadr enabled', 1;
    RECONFIGURE;

    returned

    Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62 [Batch Start Line 9]
    The configuration option 'hadr enabled' does not exist, or it may be an advanced option.

    It was not in Advanced Options. In documentation, I found this T-SQL code instead:

    SELECT SERVERPROPERTY ('IsHadrEnabled');

    and becomes enabled either in Management Studio or in PowerShell with

    Enable-SqlAlwaysOn -Path SQLSERVER:\SQL\Computer\Instance

    • This reply was modified 3 months, 1 week ago by  andre.quitta.

  • April 17, 2024 at 11:01 pm

    #4412560

    ___

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply