MIS Systems Thread, SIMS Backups in Technical; Just recently we have noticed that out backups done in SIMS are not been exported to a ZIP file so ...
17th March 2010, 09:33 AM #1
Just recently we have noticed that out backups done in SIMS are not been exported to a ZIP file so we are are ending up with massive backup files, but they were before we did an update.
Can anyone help me on how to get these backup files into a zip file during the backup process as going back to the backup file everyday and converting them to a zip file is going to be tedious.
17th March 2010, 09:40 AM #2
Yes, zipping got removed. Before this happened I create a tool to cope with it.
SIMS Tidy Backups - SQL 2008 - Autumn release
tidybackups | Get tidybackups at SourceForge.net
Hope that helps
Last edited by ZeroHour; 11th May 2010 at 04:47 PM.
2 Thanks to matt40k:
dwhyte85 (17th March 2010), Mcshammer_dj (17th March 2010)
17th March 2010, 09:44 AM #3
That was a planned change by Capita. There are reasons for it, check SupportNet.
You can script the zipping to take place, or a very helpful member has written an app that will automate the process for you. I'll go find it and post the link here.
The other option is to use a program like WinZip, WinRAR to compress them for you in bulk every so often. I've done this with WinRAR before, and it will bulk compress a bunch of files, each to a separate rar archive file at your choice of compression level, maintain the original filename, delete the original, and password protect if you wish.
17th March 2010, 09:48 AM #4
speak of the devil
Originally Posted by vikpaw
17th March 2010, 10:02 AM #5
SIMS told me to use compression on the server Not going to happen!
Thanks for posting tool
17th March 2010, 10:07 AM #6
Why? If you're only backing up at night then putting a brief extra load on the server shouldn't impact on any users? Seems sensible to me to just compress the backup folder.
Originally Posted by dwhyte85
17th March 2010, 11:08 AM #7
And what happens when you get a critical patch that your told to run during the school day? You don't want to waste time compressing. Most patches take less then 5mins to apply, even with a backup! Previously it was over and hour just to do a backup!!
Compression can happen later on when no-ones using the system along with the rest of your maintainance tasks.
17th March 2010, 11:26 AM #8
I'm can never patch during the day - don't get to take SIMS down at all during school hours as it's in constant use (Lesson Monitor!). Anyway, I've had plenty of patches fail and then had to restore the databases - wouldn't want to be doing that with a mob of angry teachers beating on my door...
17th March 2010, 11:35 AM #9
You must have a big database for compression to take that long.
Originally Posted by matt40k
17th March 2010, 11:47 AM #10
I use matt's scripts on all my schools now. The advise from Capita regarding compression was just a wate of time. All I now do is run a dbattach backup and then the tidybackups routine, with the delete level set to 45 days
17th March 2010, 02:24 PM #11
It's funny, you'd have thought, by now Capita would have bought him out and rebranded him as Capita_matt40k
Originally Posted by Mcshammer_dj
17th March 2010, 02:34 PM #12
Compression of the backup folder will cause issues with BackupExec, or at least compressed folders used to on BE?
Originally Posted by timzim
If we had a major outage, had to restore to a new folder on a new server... it used to be the case that compressed folders didn't always work once restored, albeit this wasn't SIMS.. it was pharmaceutical stuff
Last edited by dwhyte85; 17th March 2010 at 02:38 PM.
17th March 2010, 02:55 PM #13
- Rep Power
Out of interest how large does/can the SIMS database/backup become ?
Originally Posted by matt40k
We only started using SIMS in September, our backups are about 1.2GB (1700 students 11-18 secondary) and are only taking a minute and a quarter to run (modified date compared creation date).
17th March 2010, 03:06 PM #14
SQLExpress is limited to 4GB, I believe. I know schools with 6gb database which grows by 1gb per year on average, that's not including DMS!!
By matt40k in forum MIS Systems
Last Post: 11th February 2011, 02:12 PM
By WithoutMotive in forum MIS Systems
Last Post: 17th January 2008, 10:55 AM
By tech_guy in forum MIS Systems
Last Post: 7th January 2008, 02:58 PM
Last Post: 10th December 2007, 05:13 PM
By Grommit in forum MIS Systems
Last Post: 30th October 2006, 05:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)