I did some testing and figured it out.

It does not matter if you initialized the subscribers using restore a database, snapshot or whatever.

As we know: initializing the subscription using initialize from LSN needs the publication property allow_initialize_from_backup set to true.

BUT: :crying:

You have to set the allow_initialize_from_backup-option before creating the subscription(s)!

If the option is set to false when creating the subscriptions, you can change the option afterwards but initializing using LSN just won't work.

Now I have 2 questions:

1) Books online says when setting allow_initialize_from_backup to true, you should set immediate_sync to true too. Why? I neet the immediate sync to false when adding new articles! What are the consequences? :unsure:

2) Does this really mean that I have to reinitialize my subscriptions just to be ready for a failover? :w00t: :exclamation:

hmmmm......