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

sync with backup Expand / Collapse
Author
Message
Posted Thursday, February 28, 2008 12:39 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:11 AM
Points: 3,143, Visits: 137
Comments posted to this topic are about the item sync with backup
Post #461456
Posted Thursday, February 28, 2008 3:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:44 AM
Points: 251, Visits: 73
Is answer 1 not the same as answer 3
Post #461520
Posted Thursday, February 28, 2008 6:11 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:08 AM
Points: 491, Visits: 223
I understand that answer 1 implies both settings are active at the same time. However, if you answer 'both of these' one would wonder how that's wrong save for redundancy.

It is my understanding that when answering 'both of these' you need to examine both answers separately. By itself 'sync with backup" set on the distributor' is not a correct answer whereas answer 1 is.



Post #461585
Posted Thursday, February 28, 2008 8:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 10, 2011 12:13 PM
Points: 307, Visits: 565
Here is what I'm reading on msdn ms152560 (referenced in today's question)

...and these are excerpts...

In reference to the 'sync with backup' option...

Setting this option on the distribution database has no effect on replication latency.

Then a couple sentences down...

It is recommended to set this option on the publication database if your application can tolerate additional latency.

So it seems to me that setting 'sync with backup' option can increase latency when set on the publication database, but there is no effect by setting it on the distribution database.

That answer would be 'neither of these' from today's choices.

What am I missing here? Help me, HELP ME, help me!!!



If it was easy, everybody would be doing it!;)
Post #461679
Posted Thursday, February 28, 2008 8:40 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:11 AM
Points: 3,143, Visits: 137
I agree with Jeff Deluca. "Both of these" to me means situation 1 gives a "true" AND situation 2 gives a "true."

)
Post #461731
Posted Thursday, February 28, 2008 8:46 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:08 AM
Points: 491, Visits: 223
Here is something I am curious about.

Setting the option for sync with backup on the distribution database has no effect on latency by itself.

Setting the option for sync with backup on the publication database can increase latency because transactions cannot be delivered to the distribution database until they have been backed up at the Publisher.

So, if you set sync with backup on both the distribution and publication databases, does that further increase latency? The possible reason is because setting it on the distributor can increase the transaction log of the publisher. Then if the publisher has to backup a bigger log that would further increase latency. Am I correct in my thinking?

Following that reasoning, I can understand how setting the option on both would further increase latency rather than just setting it on the publisher. That would leave answer 1 to be the only correct answer.

Thanks
Post #461745
Posted Thursday, February 28, 2008 8:58 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:11 AM
Points: 3,143, Visits: 137
For Trader Sam (post 461679) and Jeff Deluca (post 461745):

First of all, the ms152560 reference says:
"It is recommended to set [the sync with backup] option on the distribution database in all cases."
To me, that means when setting sync with backup on the publisher, you would also set it on the distributor per the above recommendation.

Sync with backup causes latency only when set on the publisher.

Option 1 has sync with backup set on both publisher and distributor. Since sync with backup is set on the publisher, there will be latency. Logically, this option evaluates to "true" for the question "Will there be latency?" (Jeff - I did not have in mind the further latency that would be due to a slightly longer time to back up the log on the publisher. I only had in mind the fact that the sync with backup option should be set on the distributor in all cases.)

Option 2 has sync with backup set only on the distributor. There will be no latency in this case, so this option logically evaluates to "false."

Option 3 says "both." To me, that means both Option 1 and Option 2 would lead to latency, i.e., both would logically evaluate to "true." That is not the case.

Option 4 says "neither of these". That means, logically, that both Option 1 and Option 2 must give an answer of "false." This answer is not correct, since Option 1 gives an answer of "true."

I hope this helps. I apologize that this question was a test of both logic reasoning and the ability to interpret the logic in the Books Online reference.

)
Post #461769
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse