Replication

Replication property Retention 4

Advertisements

Check Distributor property most of the details available there.

Transaction and history retention of replication object how long to store.

Distributer property

 

Publication Retention

Change each publication from 336 hours to never expire.

Transaction Retention Period

The first setting is the Transaction Retention Period. This is defined on the distribution database. It specifies how long the transaction information is kept in the distribution database. So that subscriber can read it.

History Retention setting

This defines how long information about the health of the replication setup is kept in the distribution database. This setting does not affect the subscribers.

distribution database setting 

Profile

Profile is much important to validate the data and pass throw the data etc.

Profile setting

https://www.mssqltips.com/sqlservertip/2630/understanding-retention-periods-for-sql-server-transactional-replication/

How to check snapshot folder configured?

Snapshot Folder

Snapshot Folder 3_0Snapshot Folder 3

In general you can configure Subscription expire retention

Article – You can add or drop objects. You can modify property of each article. Like copy non clustered index , constraints etc.

Filters – You can add filters

Snapshot – You can configure snapshot location for that particular publisher.

FTP snapshot – you can leave

Subscription options – you can modify the Subscription setting

Publication access list – You can add or drop who can access publication

Agent security – You can configure snapshot and log reader agent login account.

Snapshot Folder 4

Snapshot Folder 5

Subscription settings:

Snapshot Folder 6

You can configure the distributor agent and other settings.

 

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 77 = 86