Thank you Perry for your reply! I didn't understand why AG failover is required since Clustered instance A would already be running on server B. Can you please clarify?

Thanks Phil! I'll contact their team now. Just FYI, when I run the same command used in SQL job through my login it is working fine. But not sure why...

Thanks Steve! Appreciate your response.

Thanks Kevin! That's the only option left now. :crying:

I already did sp_repldone once and was able to shrink the log file but it is happening again. Also it caused data inconsistency and fixing it is a pain.

open_tran > 0 gives me 2 rows both showing distribution agent as program name. This is because there are 2 other subscriptions on this server. This doesn't look to be...

DB is in Simple recovery mode.

Thanks Sue for your reply! Regarding distributed and non distributed LSN, my understanding is it should change continuously depending on your transaction flow. But in this case it is constant...

I have sent you an email. Does it look good to you?

Awesome script Perry! Is there an easy way to run this on multiple databases?

Adding IF NOT EXISTS for users and roles and IF EXISTS while granting rights would be a great add on. So while executing the script out it won't fail.

There are some records having different column values.