SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sync with backup


sync with backup

Author
Message
Dr. Diana Dee
Dr. Diana Dee
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3239 Visits: 143
Comments posted to this topic are about the item sync with backup
Brucethedog
Brucethedog
SSC Veteran
SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)

Group: General Forum Members
Points: 253 Visits: 73
Is answer 1 not the same as answer 3
Jeff Deluca
Jeff Deluca
Mr or Mrs. 500
Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)

Group: General Forum Members
Points: 565 Visits: 229
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.
TraderSam
TraderSam
Old Hand
Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)

Group: General Forum Members
Points: 365 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!Wink
Dr. Diana Dee
Dr. Diana Dee
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3239 Visits: 143
I agree with Jeff Deluca. "Both of these" to me means situation 1 gives a "true" AND situation 2 gives a "true."

):-D
Jeff Deluca
Jeff Deluca
Mr or Mrs. 500
Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)

Group: General Forum Members
Points: 565 Visits: 229
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
Dr. Diana Dee
Dr. Diana Dee
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3239 Visits: 143
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.

):-D
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search