Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-08-15 : 10:15:50
|
| Hello All,I have setup push transaction replication. Last week the new snapshot was taken and was delivered to the subscriber successfully but now it is again showing this message -The initial snapshot for publciation is not yet available. Can anyone tell me why every week I get this message? Shouldn't it be one time process unless any change made to the publication. Nothing changed so far.Thanks, |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-15 : 11:01:15
|
| Someone reinitialized the subscription?Subscription expired? |
 |
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-08-15 : 11:26:40
|
| How do I know if the subscription was expiring or someone reinitialized it?How do I fix it so does not happen again? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-15 : 13:08:22
|
| http://technet.microsoft.com/en-us/library/ms152490.aspx |
|
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-08-15 : 13:29:50
|
| I see the snapshot and log reader agent. Where is distribution agent? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-15 : 13:52:35
|
| It's a SQL Agent job on the server that the distribution db lives on.Also see thisedit: oops. meant this (though both are valid) |
|
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-09-06 : 16:08:00
|
| Again, the snapshot issue 'Snapshot is not available' even after running the snapshot agent just 3 days ago. Can someone please help me? I can't everytime reinitialize the subscription. There must be some setting which I am missing.Please advise. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-06 : 19:50:22
|
| What errors are you seeing in the SQL Server logs and msrepl_errors table on the distributor machine?Is the distributor dedicated, or on the publisher?What is your transaction retention period and your history retention period?What options have you set in the distributer agent profile? |
|
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-11-21 : 11:08:35
|
| Russell - here are the answers to your questions.The msrepl_errors shows these messages:TCP Provider: The semaphore timeout period has expired.Communication link failureTCP Provider: An existing connection was forcibly closed by the remote host.The distributor is on the Publisher server. Transaction retention is 0-6 days. History retention is 4 days.Distribution Agent has the Default agent profile checked.Sorry I was away for 3 weeks so doesn't reply earlier.Thanks, |
|
|
|
|
|
|
Initial snapshot is not yet available