Take the 2-minute tour ×
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.

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

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

This question came from our site for professional and enthusiast programmers.

    
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
1  
See the third section from the bottom of replicationanswers.com/NoSyncOn2005.asp titled How "initialize with backup" Works, and How to avoid Pitfalls –  crummel4 Jun 1 '13 at 1:42
1  
For step by step instructions, please refer to Initialize SQL Server replication using a database backup Also, REPLTalk has a good article on Deep Dive on Initialize from Backup for Transactional Replication –  Kin Jun 1 '13 at 3:17

1 Answer 1

up vote 2 down vote accepted

Putting the comments into an answer so the question can be marked answered:

@crummel4 says, "See the third section from the bottom of http://replicationanswers.com/NoSyncOn2005.asp titled How "initialize with backup" Works, and How to avoid Pitfalls"

@Kin says, "For step by step instructions, please refer to http://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/ or http://blogs.msdn.com/b/repltalk/archive/2010/03/16/deep-dive-on-initialize-from-backup-for-transactional-replication.aspx

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.