LLI Wiki — My Digital Knowledge Base

AG: database not synchronizing (suspend and resume)

SUSPEND/RESUME HADR statements to restart data movement for a database in an availability group, and removing a database with SET HADR OFF.

When a database in an availability group stops synchronising, suspending and then resuming its data movement is a common first step. The statements below use generic database names.

Suspend and resume data movement

ALTER DATABASE AppDb1 SET HADR SUSPEND
ALTER DATABASE AppDb4 SET HADR RESUME

ALTER DATABASE AppDb1 SET HADR SUSPEND
ALTER DATABASE AppDb1 SET HADR RESUME

ALTER DATABASE AppDb2 SET HADR SUSPEND
ALTER DATABASE AppDb2 SET HADR RESUME

ALTER DATABASE AppDb3 SET HADR SUSPEND
ALTER DATABASE AppDb3 SET HADR RESUME

Remove a database from the availability group

ALTER DATABASE AppDbName SET HADR OFF

Notes

Mastodon LLIMastodon SocialFosstodon