How can I have redundant distributor ? It can't be mirrored, clustered solution has storage as point of failure. Also what happens when distributor dies ? Do transaction logs on publisher fill up ? Any ideas ?
Are you not performing backup for replicated databases? http://msdn2.microsoft.com/en-us/library/ms151152.aspx fyi
Yes I am. Let's say i'm performing transaction log backups on distribution database every hour. Distributor fails, and I can't get to the latest transaction log (disk failure). Then I will end up with recovered distribution database on new server that is 1 hour old, and transactions in publisher's transaction log will already by read and marked for deletion and probably gone (even with sync with backup option), and I can miss up to 1 hour of transactions. Which means I will have to reinitialize or unsub/sub/manual sync my subscriptions. Am I right ?
Check the following... http://www.microsoft.com/communitie...&tid=ae632900-a55d-4941-a1ed-54252dc31baa&p=1
