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.
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.
SIMS told me to use compression on the server Not going to happen!
Thanks for posting tool
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.
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...
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
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.
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!!
There are currently 1 users browsing this thread. (0 members and 1 guests)