+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, LDF growing very quickly in Technical; My SIMS LDF file has reached 300Mb+ over the last few days, and looks like continuing to grow. Trying to ...
  1. #1

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    16

    LDF growing very quickly

    My SIMS LDF file has reached 300Mb+ over the last few days, and looks like continuing to grow. Trying to shrink it using the SQL server management studio doesn't seem to be working. Is there another way to reduce its size? Apparently there is a capita tool to fix this issue, but I can't find it.

  2. #2

    Join Date
    Oct 2005
    Location
    East Midlands
    Posts
    748
    Thank Post
    17
    Thanked 109 Times in 69 Posts
    Rep Power
    38

    Bromcom

    Hi there,

    Are you using Bromcom system with sims?

    Ash.

  3. #3
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    48
    Thanked 65 Times in 42 Posts
    Rep Power
    27
    The advisable way to reduce the Log file size is to execute a SIMS Sytem manager backup.
    This should truncate the log file along with the backup process.

  4. #4

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    16
    Yes we are using bromcom.

    This has happened before (just after going to SQL 2005), the thing is that time I dettached the DB, deleted the LDF and re-attached it with a new LDF. Our SIMS LEA support officer told me that there was a capita tool that was safer than doing this (no ammount of backups would truncate it, and it had reached 11Gb).

  5. #5
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    48
    Thanked 65 Times in 42 Posts
    Rep Power
    27
    @Rhyds - It occurs to some degree or another when any third party is involved with communicating to the SIMS System. We can make efforts to reduce the communication frequency with which our software communicates with SIMS, but I will of course need to know which school you are at If you wish to retain your user anonymity then please drop me a PM.
    This can assist in reducing the rapidity with which the log files fills but ultimately you will still need to regularly enact a SIMS System Manager backup to reduce the Log file size.

  6. #6

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    16
    We run a nightly scheduled backup of SIMS using the internal SQL 2005 backup routines, so that's not a problem.

    John: PM on the way

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367

    Lightbulb

    we had oodles of problems with this and had LDFs reaching over 20GB, yes gig not meg!

    we were always told that bromcom was to blame but got growth even with bromcom off the network. for example, in controlled conditions just the act of opening the attendance module would increase the size of the LDF.

    a system manager backup will truncate the logs and supposedly can even be run when users are on the system, but NOT however users of FMS. Anything that can be truncated will be. I always feel safer if everyone is out of the system though.

    the backup routine provided by our local support team wouldn't truncate the log no matter what we did. eventually post migration to 2005 the routine was changed to include a dbcc shrinkfile command to force truncation.

    other things to bear in mind are how the log is set to grow, i think by default ours was on a fixed percentage, which is fine when truncation is occurring but when it fails this grows exponentially. we found it better to set it to grow by a fixed size e.g. 100Mb, that way you can see what is going on, and it slows the growth rate down. Admittedly ours was an extreme example.

    Talk to Bromcom and make sure that the over night processes and imports don't coincide with the sims backups. we carefully altered our times so that they don't clash. if there is an overlap with times, things can really escalate, but the guys at bromcom can help you out with it.

    bromcom also have a very informative helpsheet covering SQL and transaction logs though i didn't end up using it as we're not supposed to run sql commands direct on our server. i've attached it in case it's of use to you.

    i just used management studio to alter the way the log grows to a fixed size, since then with the alteration to the backup routine by local support, we've not had a problem thankfully. every morning the log file is at a static 100MB so some process causes that little bit of growth up from the 1024k minimum. In the past few months its never gone above that.

    give us a shout if you want more help with bromcom side of things (we need to stick together), i used to have an issue when we forced high grade photos onto sims as the bromcom import was crashing and taking longer to complete which had knock on effects. But that's a whole different story!
    Attached Files Attached Files



SHARE:
+ Post New Thread

Similar Threads

  1. how to shrink an ldf file
    By ful56_uk in forum How do you do....it?
    Replies: 2
    Last Post: 18th May 2010, 05:36 PM
  2. Very large Citrix XenAPPRMS_log.ldf
    By cookie_monster in forum Thin Client and Virtual Machines
    Replies: 3
    Last Post: 13th May 2010, 01:00 PM
  3. Growing threat to Mobile Phones
    By tech_guy in forum General Chat
    Replies: 4
    Last Post: 18th March 2010, 05:18 PM
  4. Neighbours bush growing into my garden
    By Zoom7000 in forum General Chat
    Replies: 20
    Last Post: 20th July 2008, 04:47 PM
  5. [SIMS] sims ldf file nearly 17 gig
    By edie209 in forum MIS Systems
    Replies: 11
    Last Post: 22nd November 2007, 11:30 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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