SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Snapshots Deleted


Snapshots Deleted

Author
Message
baasha.kb
baasha.kb
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 60
Hi All,

I had a Transactional publication on MachA and subscribed to 3 different MachB, MachC, MachD.
The subscribtion was active and running fine on MachC and MachD. Whereas on MachB the subscription was not running as the MachB was out of Network for 3 Weeks continously. In the publisher i had DISABLED the job - "Distribution clean up: distribution". But the job - "Expired subscription clean up" was ENABLED.
Until 3 weeks i had Snapshot folder NOT being delted and the subscription was ACTIVE and running for MachC and MachD.
Today, when i tried to create a new Publication in MachA, Publication got created, but the Snapshot folders for previously existing publication got DELETED and the "Distribution clean up: distribution" job turn to be ENABLED in status.
How is this possible??. Does this job get automatically enabled when we create a new publication??

Also pls let me know the difference between "Distribution clean up: distribution" and "Expired subscription clean up" job. Which is the one which deletes the Snapshot folder..???

Thanks in Advance
Balaji
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search