I carried out dbShrinkfile on the log file for the primary database. However, i cant resume replication as it is giving errors
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
So you just did a “dbcc shrink file”?
You didn’t mess around removing the database from the group and switch recovery model and then shrink?
No. I only shrink the log file
Ok, what errors from replication are you facing?
you have setup replication so that all the replicas can be a publisher?
May be best to just do a full reinitialise, usually the quickest method to fix replication.
15 People are following this question.
ADVICE FOR SQL 2017 FAILOVER FOR HADR
Multi Subnet Availability Group Listener not switching to DR IP
SQL 2005 SP4 EE and SQL 2012 SP1 EE log ship to AG
Availability group query, who's my primary
SQL Server Alwayson AG ClusterName vs Listener Name