Shelby_log.ldf is getting WAY too big

Options
Eli Rosebud
Eli Rosebud ✭
Ninth Anniversary Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
Can someone help me with a bloated Shelby_log.LDF file for our NetCommunity database? We are up to 100gig and the Blackbaud KB BB419168 did not help. thanks so much,


Andrew
Tagged:

Comments

  • Warren Sherliker
    Warren Sherliker ✭
    Ancient Membership Facilitator 2 Name Dropper Photogenic
    One of our clients mentioned that it was something to do with the visitor tracker and search bots bloating the size of the table. There are scripts out there to identify the largest tables in your database so maybe run that and see which is the culprit. Would be interesting to know if it was the search bot issue so do post back if so



    SQL to run on the database Shelby: http://stackoverflow.com/questions/78... should work in later SQL versions too... Get the IT guys to run this, it just reports the values and does not alter the database.
  • Eli Rosebud
    Eli Rosebud ✭
    Ninth Anniversary Photogenic First Reply
    thanks so much Warren. I ran the query you sent me and its showing 29gig in the Stats table and then 40gig in email campaign related tables. I am not sure what to do now. I might just engage Blackbaud services.
  • Warren Sherliker
    Warren Sherliker ✭
    Ancient Membership Facilitator 2 Name Dropper Photogenic
    Sounds like a sensible step - BB services should be able to help.

Categories