What was that? Be serious and reply approriately if you know the answer

Hi,

We have transactional replication setup which replicates data from server A (SQL 2008 SP2) to Server B (SQL 2005 SP2) to Server C ( SQL 2008 RTM).

These days specially after...

Hello All,

I am still facing this issue. Every 4-5 days my snapshot invalidates. 'Initial snapshot for the publication is not yet available' I get this error.

Publication is on 2005 and...

How do I manually start the snapshot agent?

Starting the snapshot agent re snapshots all the time. I don't want the new snapshot. It should just sync the data where it was left off.

Why do I get...

Hello Guys,

I get this error often.

'Initial snapshot for this article is not yet available'

Can anyone help me why I get this error?

Yes the second option is enabled (subscriptions never expire).

Thanks,

These are the messages in msrepl_errors:

TCP Provider: The semaphore timeout period has expired.

Communication link failure

TCP Provider: An existing connection was forcibly closed by the remote host.

Does that help you?

Thanks for the reply Mohammad.

I read the article. It doesn't help in my situation.

Each publication has more than one tables to be replicated. Also the snapshot completes and then...