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

SQL replication sizes are different between source and destination Expand / Collapse
Author
Message
Posted Thursday, August 15, 2013 7:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 2, Visits: 24
Hi, have a question. We have snapshot replication set up going from production to lower level servers. The sizes of the databases are very different from production to lower environments. Can you help explain? How can i figure out where differences are:

Production: 76GB
Lower Level 1: 22GB
Lower Level 2: 16GB

Data appears to be same but as you see the sizes are drastically different. please help explain.
Post #1484749
Posted Thursday, August 15, 2013 7:21 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 9:36 AM
Points: 711, Visits: 2,211
I'm not sure if this is the same with snapshot replication as with regular transactional replication but...

With transactional replication you can choose whether to replicate indexes or not. It may be worth checking your publication settings to see whether you're replicating indexes.

The other thing is it could come down to fragmentation of indexes. if your source is heavily fragmented then it may be consuming more space than is necessary.

Thanks,


Simon




MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1484753
Posted Friday, August 16, 2013 8:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 28, 2014 8:09 AM
Points: 316, Visits: 592
In addtion to the above which is the most likely scenario. Are you using any filters in your indexes and are you copying all attributes as part of your articles?

MCITP SQL 2005, MCSA SQL 2012
Post #1485231
Posted Friday, August 16, 2013 8:27 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 9:36 AM
Points: 711, Visits: 2,211
RTaylor2208 (8/16/2013)
In addtion to the above which is the most likely scenario. Are you using any filters in your indexes and are you copying all attributes as part of your articles?


Great catch. I hadn't thought of that.




MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1485233
Posted Friday, August 16, 2013 11:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 2, Visits: 24
all data is replicated: tables, views, etc...

thanks for all your help
Post #1485335
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse