Snapshot agent not applying snapshot if @sync_type = N'replication support only'

All~,

Is it true that , if a subscription is created with parameter


@sync_type = N'replication support only'
, then even if we generate a new snapshot by restarting the snapshot agent , then snapshot will not be applied to the subscriber . Because I am facing this, I create a subscription with 'replication support only ' opion, snapshot is not being applied. But If we create a subscription with


@sync_type = N'automatic'

,in this case, Snapshot agent is working cool.

Please respond , how can I update subsciber with a fresh snapshot, if @sync_type = 'repliation support only'.

Here is the complete script to create subscriber:


-- Adding the transactional subscriptionsUSE [ReplTesting]EXEC sp_addsubscription @publication = N'Repltesting_mine', @subscriber = N'D2DB01', @destination_db = N'SubsTesting', @subscription_type = N'Push', @sync_type = N'replication support only', @article = N'all', @update_mode = N'read only', @subscriber_type = 0EXEC sp_addpushsubscription_agent @publication = N'Repltesting_mine', @subscriber = N'D2DB01', @subscriber_db = N'SubsTesting', @job_login = N'peoplenetsqlserver', @job_password = 'sqlserver', @subscriber_security_mode = 1, @frequency_type = 64, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 4, @frequency_subday_interval = 5, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @active_start_date = 0, @active_end_date = 0, @dts_package_location = N'Distributor'GO

Hello Fais,
The whole point of "replication support only" is to not apply the snapshot at the subscriber. If you must use this option - even though it doesn't seem that this is what you want - have a look at the "How to: Initialize a Subscription Manually (Replication Transact-SQL Programming)" in BoL for differerent ways to initialize the subscriber when this option has been set.
HTH
/Elisabeth