I had meant to fire the @sync_type ='none' with the sp_addsubscription and
had all data present on both publisher and subscriber.

My snapshot hasnt started yet, so how can i avoid pushing the whole snapshot
again when the snapshot agent runs ?

Using trans replication

You can't really do this cleanly. The hacking approach is to remove the
related transactions and commands from the distribution database - use the
xact_seqno as a basis for this. Stop the distribution agent before the
snapshot has completed and delete the commands once they are posted.

I would urge you to be really careful here, especially if this is a
production system. You might want to back up both of these tables before you
do it.

A safer approach is to drop the subscription and do a no-sync.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]