How to check hadr state (suspend or resume) for a database?

-1 votes

1 answer

642 views

I can use below statements to suspend or resume HADR for a database.

ALTER DATABASE test SET HADR SUSPEND;
ALTER DATABASE test SET HADR RESUME;

How can I check a database is in HADR suspend or resume state using TSQL?

Asked by Fajela Tajkiya (1239 rep)

Apr 13, 2023, 01:37 PM
Last activity: Apr 13, 2023, 02:23 PM