Hi All,

I have several publications (transactional replication). For some of the
publications I have observed that the snapshot
folder(repldata\unc\pubfolder\folder_with_datetime _stamp) are still having
the snapshot(folder_with_datetime_stamp). And for some of the publications
the folder is blank.

I want to know whether there is any setting in the replication Stored procs
which prevents snapshot to delete(or retain) after the snapshot is applied.

Thanks,
Siddu

Has the retention period been exceeded for these particular snapshots?
Paul Ibison

The retention is zero. The parameters used for adding publication are :

exec sp_addpublication

@add_to_active_directory = N'false',

@allow_anonymous = N'false',

@allow_dts = N'false',

@allow_initialize_from_backup = N'false',

@allow_pull = N'true',

@allow_push = N'true',

@allow_queued_tran = N'false',

@allow_subscription_copy = N'false',

@allow_sync_tran = N'false',

@autogen_sync_procs = N'false',

@compress_snapshot = N'false',

@description = @descr,

@enabled_for_het_sub = N'false',

@enabled_for_internet = N'false',

@enabled_for_p2p = N'false',

@ftp_login = N'anonymous',

@ftp_port = 21,

@immediate_sync = N'false',

@independent_agent = N'true',

@post_snapshot_script = @post_snap,

@publication = @pubname,

@repl_freq = N'continuous',

@replicate_ddl = 1,

@retention = 0,

@snapshot_in_defaultfolder = N'true',

@status = N'active',

@sync_method = N'concurrent'

"Paul Ibison" <Paul.Ibison (AT) ReplicationAnswers (DOT) Com.(donotspam)> wrote in
message news:C9FEE2A8-E15A-4B7D-A827-3BACD834F6FF (AT) microsoft (DOT) com...

Is this a SQL 2000 publication? If so, you have allow_anonymous set to false
so this should allow for the automatic removal of the snapshot once the named
subscribers have all initialized.
HTH,
Paul Ibison

Thanks Paul. Mine is sql2005. allow_anonymous is already set to false. but
the same behaviour

Thanks,
Siddu

"Paul Ibison" <Paul.Ibison (AT) ReplicationAnswers (DOT) Com.(donotspam)> wrote in
message news:2E7E9180-6C1C-41E7-8039-8738C6EB4EA6 (AT) microsoft (DOT) com...