Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Filter article for Snapshot and then remove Expand / Collapse
Author
Message
Posted Wednesday, November 28, 2012 5:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 2:15 AM
Points: 58, Visits: 301
Hello all,

I am setting up a transactional replication job between two servers and I am trying to find out if it is possible to filter my publication when I create the snapshot and then remove the filters without needing to re-initialize the subscription.
My publisher has about 7 years worth of data in 6 large tables and I would like to filter these tables to 1 year of data for my initial snapshot so that it initializes quickly but then have subsequent transactions ignore the filter to optimize performance of the log reader agent. According to the documentation, if I remove the filter on the publication, the subscription must be re-initialized which defeats the purpose of what I am trying to do. Is there any way around this?
Post #1389680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse