+ Post New Thread
Results 1 to 7 of 7
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 ...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,907
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93

    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?

  2. #2

    Join Date
    Jan 2008
    Location
    Cheshire, UK
    Posts
    340
    Thank Post
    68
    Thanked 60 Times in 42 Posts
    Rep Power
    48
    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.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,157
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    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.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    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?

  5. #5
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,907
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93
    Quote Originally Posted by vikpaw View Post
    I wouldn't say you've got a problem. How long does your backup take?
    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.

    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

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    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.

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. How big is yours?
    By Hightower in forum Windows Server 2008 R2
    Replies: 11
    Last Post: 9th August 2011, 02:25 PM
  2. [WDS] How big is your boot image?
    By Tricky_Dicky in forum O/S Deployment
    Replies: 18
    Last Post: 27th July 2011, 11:48 AM
  3. How big is your printing budget?
    By JJonas in forum Budgets and Expenditure
    Replies: 16
    Last Post: 8th January 2009, 01:33 PM
  4. How big is your backup?
    By DavidB4910 in forum Wireless Networks
    Replies: 16
    Last Post: 25th May 2007, 09:14 AM

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
  •