SQL Server Performance

Distributor

Discussion in 'SQL Server 2005 Replication' started by why, Oct 23, 2007.

  1. why New Member

    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 ?
  2. satya Moderator

  3. why New Member

    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 ?
  4. MohammedU New Member

Share This Page