MIS Systems Thread, transaction logs in Technical; Should I be doing anything with the transaction logs for Sims?
I've just setup our backup and its complaining that ...
17th September 2010, 01:45 PM #1
Should I be doing anything with the transaction logs for Sims?
I've just setup our backup and its complaining that the transaction logs are not being backed up and could grow exponentially.
V-79-40960-37914 - Database Sims is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.
EDIT: I just noticed our LDF file is 5.6gb
Last edited by zag; 17th September 2010 at 02:19 PM.
18th September 2010, 12:11 PM #2
Have you just moved server or to the new SQL 2008?
The regular backups should truncate the transaction logs. 5.6 is immense and will defo cause you problems.
I'm no SQL expert but there are ways to just run Truncate commands.
I would try a system manager backup from SIMS itself, this used to do the job, if that doesn't work, try a Full Backup using SQL management studio which should also truncate the log file. If they don't work, post back.
I'm not sure now, but the old routine used to create a backup and then zip it too, but to do all that requires as much free space as you are backing up, so depending on the size of your MDF i'd ensure that you have at least 5.6GB plus mdf size free.
A very long time ago, at another school, in a country far far away, we had massive truncation problems and one reason for the massive growth was that it was set to expand by 10%, this was easily curbed by setting it to increase by a fixed amount, e.g. 100MB, so it wouldn't spiral out of control, but it does need close monitoring on a regular basis, or set up alerts for a long term solution.
Hope you get it sorted quickly.
Last edited by vikpaw; 18th September 2010 at 12:12 PM.
18th September 2010, 02:20 PM #3
If you download the ESS Upgrade utility from Capita Education Support Services (Link is under the latest patch) and run it, log in to the Database as if you were going to do an upgrade and then click on Tools.
It should then show you the log file sizes and give you the option to truncate them if I remember rightly. Can't check right now, but made a point of asking the engineer who did our Migration how to manage it.
20th September 2010, 08:43 AM #4
Thanks, I worked out its just because we are still using SQL 2005.
I guess when I finally bother doing the upgrade to SQL 2008 this problem will disappear.
20th September 2010, 03:06 PM #5
@jinnantonnix - that's confused me know because in the past i've had people refer to truncating of the logs as also reducing the physical file size. in fact the sysman backup used to do just that and reduce the .ldf file to 1024kb from however many MB it had reached. I guess this was just bad use of technical SQL terminology.
So really what is needed is to shrink the log file, and part of doing that could involve truncating it too...? sounding closer to reality?
26th October 2010, 01:19 PM #6
By albertwt in forum Enterprise Software
Last Post: 23rd February 2011, 10:21 PM
By Disease in forum MIS Systems
Last Post: 13th July 2010, 01:27 PM
By badders in forum Internet Related/Filtering/Firewall
Last Post: 17th July 2009, 02:59 PM
By alan-d in forum Virtual Learning Platforms
Last Post: 21st November 2007, 02:30 PM
By srochford in forum How do you do....it?
Last Post: 13th April 2007, 12:53 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)