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

Replication 2008 - log-based indexed-view-to-table Expand / Collapse
Author
Message
Posted Thursday, September 20, 2012 2:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 10, 2014 2:42 AM
Points: 1, Visits: 47
Hi,

We are setting up a Transactional Replication and we are having some issues with an indexed view that slows down the initial snapshot. I read here that we could replicate the indexed view as table, so we are trying to do that, but the Indexed View is not replicated.

Can you tell me if it is still possible in Sql Server 2008 or do we need another approach?

The problem is the indexes we have in the Indexed View, another solution is to disable all the indexes and rebuild the indexes at the end of the initial snapshot.

The databases are not identical, we are only replicating some articles between them.

Thanks.
Post #1361790
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse