Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 4 down vote favorite

There is an option when setting up a publication for replication to Allow Initialization From Backup. We have been creating replicated databases for several years now and have always initialized from a backkup but have never set this flag (we just noticed it for the first time a couple of days ago). The replication certainly has worked without issue all this time.

I've found a lot of hits explaining that this needs to be used but none that explain why.

Does anyone have an understanding of what this actually does? From my vantage, it doesn't seem to be necessary but I'm thinking I have to be missing something.

share|improve this question
Are the publications enabled for Peer-to-Peer (even if you aren't using them for that)? If so, the initialize from backup setting defaults to true even when it isn't specified. msdn.microsoft.com/en-us/library/ms188738.aspx – Jon Seigel Sep 18 '12 at 17:20
We are using straight 1 way transactional replication and I have verified the flag is set to false. I'm going to set it to true going forward but would like to understand its purpose. – Gizmo Sep 19 '12 at 4:52

migrated from stackoverflow.com Sep 18 '12 at 14:26

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.