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.
Answer by FemiFolarin · Jun 01 at 02:14 PM
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.
Answer by anthony.green · Jun 01 at 02:11 PM
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?
Answers Answers and Comments
15 People are following this question.
What will happened if quorum would not available in case of Disaster Recovery?
Does SQL 2016 Standard Edition SP1 support automatic failover for Availability groups in synchronous-commit
If I update a database that is in an availability group, will the replica update as well
Availability Group Replica(s) on VM Nodes
SQL 2012 Always on DR test approach