question

FemiFolarin avatar image
FemiFolarin asked

How do I restart Replication in always on availability group after log file truncation on primary database

I carried out dbShrinkfile on the log file for the primary database. However, i cant resume replication as it is giving errors

availability-groups
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
anthony.green avatar image
anthony.green answered

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?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

FemiFolarin avatar image
FemiFolarin answered

No. I only shrink the log file

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

Ok, what errors from replication are you facing?

you have setup replication so that all the replicas can be a publisher?

0 Likes 0 ·
anthony.green avatar image anthony.green commented ·

May be best to just do a full reinitialise, usually the quickest method to fix replication.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.