Distribution Data getting too big

• Mr J

  Hall of Fame

  Points: 3595

  More actions

  January 21, 2009 at 2:43 pm

  #94457

  Hi Guys

  I have a production server that's being used for replication and I've noticed that the Distribution database is monstrous, is there anyway for me to reduce it in size, will changing the db to simple mode and then shrinking it kill it ??

  Remember
  Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  January 26, 2009 at 4:47 am

  #932522

  Hi,

  Are you backing it up ?

  Are you running the Distribution Cleanup jobs that are created when you create the Distribution database ?

  Regards

  Graeme