Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Unanswered: Large Distribution database

    Hi guys

    We have replication setup between our Production and Reporting server, the distribution database which sits on the Production server is 59Gb in size and is growing, the log file is relatively small but the .mdf file is the big one. The recovery model of this db is set to simple. What can i do to reduce and manage the size of the distribution db?

    Production server specs: SQL 2005 Standard Edition SP3, running on Windows Server 2003, 4x Intel Pentium processors, 4Gb Ram.

    Thank you
    Ru

  2. #2
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59
    what type of replication?
    MohammedU
    SQL Server MVP

  3. #3
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59
    Check FIX: A distribution database may grow continuously on one of the nodes when you configure a peer-to-peer transactional replication in SQL Server 2005 Service Pack 2
    and make sure you don't have any open transactions by running DBCC OPENTRAN and also make sure "Distribution cleanup" job is running...
    If it is running, try running manually in query window and see what happens...
    MohammedU
    SQL Server MVP

  4. #4
    Join Date
    Aug 2009
    Posts
    3
    Hey guys

    I realized that there was a job to clean up the distribution database, the job however has been failing for the last couple of months.

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •