msdb size growing!!!

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 27, 2011 at 12:55 am

  #1316387

  Curious, are you also using SSIS? If so, where do you store the packages, SQL Server or File System?

• samsql

  Hall of Fame

  Points: 3044

  More actions

  May 3, 2011 at 8:47 pm

  #1319508

  no Lynn we are not using any packages ..... so wat shud be action plan...

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 3, 2011 at 8:51 pm

  #1319509

  You can always move to simple recovery, then delete in small batches so the log doesn't grow on you within the transaction.

  But AFAIK you haven't tested all of Perry's options.

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  May 3, 2011 at 11:53 pm

  #1319540

  samsql (5/3/2011)

  ---

  . so wat shud be action plan...

  See my last response above!!

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"