Hi,

I have a question, i am managing 2 SQL servers

1 is Master Server (Publisher + Distributor)

2 is Client Server (Subscriber)

client basically owned by a client who is buying data from us.

Both Servers are replicated with each other

Replication type is Transactional-replication

only selected Tables of a single DB are replicated from Master-Server to Client Server.

Now i am going to tell actual problem. Basically there are several problems i want to discus

Problem 1:

When i add or delete any data table and take snapshot of replication than all db vanishes from customer side and after that it rebuilds in 20-30 minutes (have limited access so don't get logs)

Problem 2:

When i reinitialize subscription than it takes lots of time to completing it and showing partially applied scripts of tables in monitoring.

Problem 3:

Publisher to Distributor showing high commands and transactions count but actually on distributor to subscriber commands and transaction counts are more than 100's of times lower as compare to publisher section.

Problem 4:

Latency is Very high between Publisher-Distributor (around 5+ minutes)(Server-1) and jumps to 7 minutes then automatically less and stay on some seconds but average is really very high. Distributor-Subscriber latency seems fine.

Problem 5:

Log Size of Master DB increases and occupying space around 3.5 GB (Normally 3 GB with 80-87% free space) whether Data File Size also increases and now it's 4 GB+ (Normally 3.3 - 3.5 GB)

Really Appreciate Your Suggestions and Guidelines.

Thanks in advance,

Hassan