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.
Creating Availability Group the Databases on the Secondary are Stuck in Restoring State?
Run SSISDB without AlwaysOn in SQL 2012
how to Shrink LDF On the Always-On environment
Planned failover of AlwaysOn Availability Groups
How to add sql server to existing availability group on the same subnet