The concurrent snapshot for publication 'xx' is not available because it has not been fully generated or the Log Reader A

Question

I am having all sorts of trouble getting SQL Server (2005) to work properly. When I run the client (SQL Server Express 2005) I get the following error "The concurrent snapshot for publication 'xx' is not available because it has not been fully generated or the Log Reader A"

The error is cropped off.

I have tried: - Deleting the subscription - Deleting the publication and starting again - Restarting the server and client. - Shrinking the database

All without any change.

I know that the client can see the network share \servername\repldata which has a UNC subfolder with the snapshot in it (a folders deeper with the pubName and dateTime encoding as expected)

Any tips or trips would be REALLY appreciated

Answer 1

1. Has the snapshot for the publication been generated? Sometimes this takes a looong time and sometimes it gets deferred to a later time. If it is made, you should be able to find it on disk somewhere.

2. Make sure that the Log Reader is running on the Publisher, if this is Transactional Replication, which I assume it is.