The concurrent snapshot for publication is not available because it has not been fully generated .

Problem:-

The snapshot files for a transactional publication are immediately removed after being generated by the snapshot agent.

Noticed that status of the publication articles are 3. Which is wrong either they should be 0 = Inactive, 1 = Subscribed or 2 = Active.

Solution :-

1) Delete the subscription and publication.

2) Check the tables to see if there are still rows for the publication database available:

select * from msdb..MSdistpublishers

select * from distribution..MSpublisher_databases

select * from distribution..MSarticles where publisher_db = 'distribution'

select * from distribution..MSsubscriptions where publisher_db = 'distribution'

3) Delete all rows that have still the 'publisher_db' from the just deleted publisher database:

delete from distribution..MSarticles where publisher_db = 'distribution'

delete from distribution..MSsubscriptions where publisher_db = 'distribution'

4) Re-create the publication subscriber and initialize.

Help Links :-

http://blogs.technet.com/b/claudia_silva/archive/2009/04/29/replication-snapshot-files-removed-after-being-generated.aspx

http://support.microsoft.com/kb/324401

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/baf99181-2fe1-4e6b-ba45-5d1d08103550/initialize-subscription-failing

http://stackoverflow.com/questions/1018339/the-concurrent-snapshot-for-publication-xx-is-not-available-because-it-has-not