+ Post New Thread
Results 1 to 14 of 14
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 ...
  1. #1

    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,198
    Thank Post
    321
    Thanked 314 Times in 219 Posts
    Rep Power
    125

    SIMS Backups

    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.

    Thanks

    Tim

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Yes, zipping got removed. Before this happened I create a tool to cope with it.

    Tidybackups
    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.

  3. 2 Thanks to matt40k:

    dwhyte85 (17th March 2010), Mcshammer_dj (17th March 2010)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    774
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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.

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    774
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Quote Originally Posted by vikpaw View Post
    ...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.
    ...
    speak of the devil

  6. #5
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    SIMS told me to use compression on the server Not going to happen!

    Thanks for posting tool

  7. #6

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    Quote Originally Posted by dwhyte85 View Post
    SIMS told me to use compression on the server Not going to happen!
    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.

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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.

  9. #8

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    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...

  10. #9
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Quote Originally Posted by matt40k View Post
    Previously it was over and hour just to do a backup!!
    You must have a big database for compression to take that long.

  11. #10
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    991
    Thank Post
    39
    Thanked 180 Times in 145 Posts
    Rep Power
    97
    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

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    774
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Quote Originally Posted by Mcshammer_dj View Post
    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
    It's funny, you'd have thought, by now Capita would have bought him out and rebranded him as Capita_matt40k

  13. #12
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    Quote Originally Posted by timzim View Post
    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.
    Compression of the backup folder will cause issues with BackupExec, or at least compressed folders used to on BE?

    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.

  14. #13

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by matt40k View Post
    Most patches take less then 5mins to apply, even with a backup! Previously it was over and hour just to do a backup!!
    Out of interest how large does/can the SIMS database/backup become ?

    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).

    tim

  15. #14

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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!!



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release
    By matt40k in forum MIS Systems
    Replies: 50
    Last Post: 20th October 2014, 01:45 PM
  2. SIMS Backups with SQL 2005
    By WithoutMotive in forum MIS Systems
    Replies: 5
    Last Post: 17th January 2008, 10:55 AM
  3. Error Doing Tidy Backups in Sims.Net
    By tech_guy in forum MIS Systems
    Replies: 0
    Last Post: 7th January 2008, 02:58 PM
  4. Backups
    By Geoff in forum *nix
    Replies: 8
    Last Post: 10th December 2007, 05:13 PM
  5. SIMS Backups
    By Grommit in forum MIS Systems
    Replies: 21
    Last Post: 30th October 2006, 05:32 PM

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
  •