turn off SQL Server High availbility

Question

Hi all,

Our SQL Server instance has Always on high availability groups on for all user databases , the secondary server windows OS crashed.

we have decided to shut down always on high availability for all user databases.

Please provide what is the best way to accomplish this.

Answer 1

Hi @sqlniks-7244,

All user databases add to SQL server Always On availability group? Please remove SQL availability group to remove always on high availability for all user databases. If I misunderstood your issue, please let me know.

On primary replica, using SSMS UI or T-SQL as below to remove SQL Server Always On Availability Group Configuration.

DROP AVAILABILITY GROUP AG1;  

After this operation, please refresh the "Availability Group" folder.

Please refer to [Remove an availability group (SQL Server)][2] to get more information.

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

[2]: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/remove-an-availability-group-sql-server?view=sql-server-ver15 [4]: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/remove-a-primary-database-from-an-availability-group-sql-server?view=sql-server-ver15