Could you check the row count of MSrepl_commands before and after the distribution clean job runs.

The data in the MSrepl_commands table in distribution database should be reducing. Also your immediate_sync...

ok... Can you provide us this information

1)

use distribution

go

sp_helpdistributiondb

What is the value of min_distretention and max_distretention

2) Is the Distribution clean up: distribution job running? When did it last run?

3) What...

You won't lose any data

Can you check the immediate_sync property in the publication database

use publication_db_name

go

sp_helppublication

is immediate_sync =1 ?

You are describing log shipping. There will be some latency involved when you are dealing with log shipping.

By the by, what is the latency duration.

Why do you want...

Thanks for easy question.

Is the subscriber in sync?

@mohammed

I'll echo Tom - I was pretty annoyed to spend time trying to get the question right according to the exact wording and find I still had it...

L' Eomot Inversé (4/16/2012)

---

mohammed moinudheen (4/16/2012)

---

Sorry for the confusion. The question and answer was meant to test your knowledge on the log file backup size only and not the log...

Sorry for the confusion. The question and answer was meant to test your knowledge on the log file backup size only and not the log file. Somehow the wording was...

Thanks for sharing your wonderful experience. Atleast I could learn a new word:Cacoëthes Scribendi

Good one.

Are you configuring this distribution database on another server. Just checking if you are checking on the correct server?

Good question, learned something. Thanks.

Good question