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

Snapshot replication for large database Expand / Collapse
Author
Message
Posted Tuesday, August 11, 2009 11:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 8, 2010 10:45 PM
Points: 122, Visits: 70
Hi
is snapshot replication is supported for large databases??? can anyone please help me out in this regard..
as i am confused with the statements
"Snapshot replication has a lower continuous overhead on the Publisher than transactional replication, because incremental changes are not tracked. However, if the dataset set being replicated is very large, it will require substantial resources to generate and apply the snapshot. Consider the size of the entire data set and the frequency of changes to the data when evaluating whether to utilize snapshot replication. "

my database is of 20GB.




Thanks ,

Shekhar

Post #769111
Posted Wednesday, August 12, 2009 1:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:57 PM
Points: 310, Visits: 650
No issues. The statement only informs you that you will have stale data if there are very frequent changes :p. From where you got this statement by the way?

-LK
Post #769150
Posted Wednesday, August 12, 2009 4:57 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:31 AM
Points: 999, Visits: 13,473
As above the statement is just warning you about the size of the snapshots, if you snapshot a 20gb database then everytime you sync the data you are moving 20gb each time. By design transactional replication does at it says on the tin, it moves over the required transactions, so they are a lot smaller than the complete db. The use of both replication types though are very different and you need to use the one that works in your environment.
Post #769203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse