MIS Systems Thread, How big is your Sims database in Technical; I'm just sorting out a SQL backup each night for our Sims DB and noticed how large the actual .bak ...
26th November 2012, 10:46 AM #1
How big is your Sims database
I'm just sorting out a SQL backup each night for our Sims DB and noticed how large the actual .bak file is.
sims.bak = 2.3GB and zips down to about 500gb.
Is this typical?
That seems really big to me although we do use lesson by lesson registration features.
Is there any way to reduce the size for quicker backups?
26th November 2012, 10:55 AM #2
Ours are much larger!
sims.bat = 5G
Zipped = 1.1G
We use PARS so I would guess that will make some difference. As to making smaller, I can't help there one of the SIMS experts around here might be able to help.
Our SIMS backup including zipping only takes about 10 minutes on our virtual server.
26th November 2012, 10:58 AM #3
SIMS.mdf is 1.5GB
Zipped, it goes down to 390Mb.
That's for a 550 pupil school who have been using it for a decade now. Don't think you're going to have much luck shrinking it, as it just holds all that old data, and will therefore continue to grow constantly.
This one has grown by about 800Mb in the last 6 years.
26th November 2012, 11:10 AM #4
You mean it shrinks to 500MB!
My 4.3GB MDF becomes a 3.99GB .bak - this shows you how much space there is, but having a little isn't a big deal, if the difference is too big you could claw that back and alter growth settings but i doubt that's an issue.
It then compresses to a nice 1.25GB. In Feb it was 1.1GB. That's with up to 1500 students and lesson monitor plus lots of reporting.
I wouldn't say you've got a problem. How long does your backup take?
26th November 2012, 12:09 PM #5
Backup only takes 4mins on the virtual ssd server, but I was hoping to reduce the stress on the disk drives over the years. Backing up 2gb of data each night seems a little much.
Originally Posted by vikpaw
I guess its pretty standard though, just cant understand what takes up all the space! Maybe its the pupil pictures.
Just as a comparrison I run some mysql sites with millions of records and they take something ridiculous like 50mb of space which zips down to about 6mb
26th November 2012, 01:09 PM #6
I run a separate photo database where we take the photos and then they get transferred to SIMS. The student area on that comes to around 3GB, so you're probably right, even though comparison isn't fair as mine is a custom db with the data in a weird proprietary format.
26th November 2012, 01:37 PM #7
2gb is a common size for a secondary school. I did have a school that's database was much larger and Capita was able to trim out some of the old data - such as back in 2004 teacher y changed their password. As interesting as that kinda info was, it was around 1GB!!
Would recommend a good backup solution such as Attix5\Redstor\RBUSS, it does a full backup then does a bit level compare and only uploads the changes. SSD wise, I would only worry about it if you've got non-enterprise grade discs.
By Hightower in forum Windows Server 2008 R2
Last Post: 9th August 2011, 02:25 PM
By Tricky_Dicky in forum O/S Deployment
Last Post: 27th July 2011, 11:48 AM
By JJonas in forum Budgets and Expenditure
Last Post: 8th January 2009, 01:33 PM
By DavidB4910 in forum Wireless Networks
Last Post: 25th May 2007, 09:14 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)