SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Initial snapshot is not yet available		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqlpal2007
Posting Yak Master

182 Posts
Posted - 08/15/2011 :  10:15:50  Show Profile  Reply with Quote
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

USA
4968 Posts
Posted - 08/15/2011 :  11:01:15  Show Profile  Visit russell's Homepage  Reply with Quote
Someone reinitialized the subscription?
Subscription expired?
Go to Top of Page

sqlpal2007
Posting Yak Master

182 Posts
Posted - 08/15/2011 :  11:26:40  Show Profile  Reply with Quote
How do I know if the subscription was expiring or someone reinitialized it?

How do I fix it so does not happen again?
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4968 Posts
Posted - 08/15/2011 :  13:08:22  Show Profile  Visit russell's Homepage  Reply with Quote
http://technet.microsoft.com/en-us/library/ms152490.aspx
Go to Top of Page

sqlpal2007
Posting Yak Master

182 Posts
Posted - 08/15/2011 :  13:29:50  Show Profile  Reply with Quote
I see the snapshot and log reader agent. Where is distribution agent?
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4968 Posts
Posted - 08/15/2011 :  13:52:35  Show Profile  Visit russell's Homepage  Reply with Quote
It's a SQL Agent job on the server that the distribution db lives on.

Also see this

edit: oops. meant this (though both are valid)
Edited by - russell on 08/15/2011 13:57:08
Go to Top of Page

sqlpal2007
Posting Yak Master

182 Posts
Posted - 09/06/2011 :  16:08:00  Show Profile  Reply with Quote
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.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4968 Posts
Posted - 09/06/2011 :  19:50:22  Show Profile  Visit russell's Homepage  Reply with Quote
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?
Go to Top of Page

sqlpal2007
Posting Yak Master

182 Posts
Posted - 11/21/2011 :  11:08:35  Show Profile  Reply with Quote
Russell - here are the answers to your questions.

The msrepl_errors shows these messages:
TCP Provider: The semaphore timeout period has expired.
Communication link failure
TCP 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,
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000