Run the following script to identify whether HA has been enabled:

-- ========================================
-- SQL Server High Availability Check
-- ========================================

-- 1. Always On Availability Groups
PRINT '--- Always On Availability Groups ---';
SELECT * FROM sys.availability_replicas;
SELECT * FROM sys.dm_hadr_availability_replica_cluster_nodes;
DECLARE @IsHadrEnabled AS sql_variant;  
SET @IsHadrEnabled = (SELECT SERVERPROPERTY('IsHadrEnabled'));  
SELECT 
    @IsHadrEnabled AS IsHadrEnabled,  
    CASE @IsHadrEnabled  
        WHEN 0 THEN 'Always On availability groups are DISABLED'  
        WHEN 1 THEN 'Always On availability groups are ENABLED'  
        ELSE 'Invalid Input'  
    END AS HadrStatus;

-- 1a. Distributed Availability Groups
PRINT '--- Distributed Availability Groups ---';
IF EXISTS (
    SELECT 1 
    FROM sys.columns 
    WHERE object_id = OBJECT_ID('sys.availability_groups') 
      AND name = 'distributed_network_name'
)
BEGIN
    EXEC sp_executesql N'
        SELECT 
            name AS AG_Name, 
            distributed_network_name 
        FROM sys.availability_groups 
        WHERE distributed_network_name IS NOT NULL;
    ';
END
ELSE
    PRINT 'Distributed Availability Groups not supported on this SQL Server version.';

-- 2. Log Shipping
PRINT '--- Log Shipping Primary Databases ---';
SELECT * FROM msdb.dbo.log_shipping_primary_databases;
PRINT '--- Log Shipping Secondary Databases ---';
SELECT * FROM msdb.dbo.log_shipping_secondary_databases;

-- 3. Database Mirroring
PRINT '--- Database Mirroring ---';
SELECT
    db.name AS Database_Name,
    db.state_desc AS DB_State,
    dm.mirroring_role_desc,
    dm.mirroring_state_desc,
    dm.mirroring_safety_level_desc,
    dm.mirroring_partner_name,
    dm.mirroring_partner_instance
FROM sys.databases AS db
INNER JOIN sys.database_mirroring AS dm 
    ON db.database_id = dm.database_id
WHERE dm.mirroring_guid IS NOT NULL;

-- 4. Failover Cluster Instance (FCI)
PRINT '--- SQL Server Failover Cluster Instance (FCI) ---';
SELECT 
    @@SERVERNAME AS Server_Name,
    CASE 
        WHEN SERVERPROPERTY('IsClustered') = 1 
            THEN 'SQL Server instance is part of a Failover Cluster' 
        ELSE 'SQL Server instance is NOT part of a Failover Cluster' 
    END AS IsClustered;

-- 5. Replication
PRINT '--- Replication Publications ---';
IF EXISTS (SELECT * FROM sys.databases WHERE name = 'distribution')
BEGIN
    SELECT publisher_db, publication, publication_type, sync_method
    FROM msdb.dbo.MSpublications;
END
ELSE
    PRINT 'Replication not configured (distribution database missing).';

PRINT '--- Replication Subscriptions ---';
IF EXISTS (SELECT * FROM sys.databases WHERE name = 'distribution')
BEGIN
    SELECT subscriber_db, publication, subscription_type, status
    FROM msdb.dbo.MSsubscriptions;
END;

-- 6. Azure SQL Built-in HA
PRINT '--- Azure SQL HA Info ---';
SELECT 
    DB_NAME() AS Database_Name,
    DATABASEPROPERTYEX(DB_NAME(), 'ServiceObjective') AS Service_Tier,
    DATABASEPROPERTYEX(DB_NAME(), 'Edition') AS Edition;

-- 7. Availability Groups Summary
PRINT '--- Summary of Availability Groups ---';
SELECT 
    ag.name AS AG_Name,
    ag.is_distributed,
    ag.failure_condition_level,
    ag.health_check_timeout,
    ar.replica_server_name,
    ar.availability_mode_desc,
    ar.failover_mode_desc
FROM sys.availability_groups AS ag
JOIN sys.availability_replicas AS ar
    ON ag.group_id = ar.group_id;

PRINT '--- High Availability Check Completed ---';

If High Availability (HA) is found to be enabled, disable all HA configurations.

For more information see Snow Software’s documentation on software requirements.