+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, MSSQL backups from SIMS filling drive space in Technical; Anyone have these (attached)? No specific schedule. Some are recent. Taking lots of space. How are these managed, why are ...
  1. #1

    Join Date
    Sep 2011
    Posts
    162
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    MSSQL backups from SIMS filling drive space

    Anyone have these (attached)? No specific schedule. Some are recent. Taking lots of space. How are these managed, why are they there, are they safe to move or remove?
    Attached Images Attached Images

  2. #2
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    936
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    if you search this site you will find reference to @Matt40 's wonderful utility which will zip the backups for you and remove them after a set amount of time.

    Tidybackups

    they are created ever time SIMS is upgraded or the database is patched. In reality you should only need to keep one as I doubt that you will want to go back any earlier.
    Last edited by Mcshammer_dj; 20th April 2012 at 04:08 PM.

  3. Thanks to Mcshammer_dj from:

    matt40k (21st April 2012)

  4. #3

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    depending on your version of SQL you can get SQL manager to delete older backups automatically while its doing a backup.

  5. #4

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,740
    Thank Post
    145
    Thanked 553 Times in 497 Posts
    Rep Power
    151
    I have robocopy set on a schedule to move them off the server onto a NAS, that way a huge number of backups can be kept (not that it's really necessary to keep many).

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    i try to keep as many as i can. never going to full restore, but useful to restore to a test server and view data sometimes, as a way of auditing. also to copy back odd reports, templates if they get corrupted.
    you should be able to zip / rar those to a third of the size. Then keep them there or move off to regular backup store.
    They are not managed, but it is safe to move / remove. Presumably you have some other backup system, working at least nightly...

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    tidybackups | Free software downloads at SourceForge.net - TidyBackups can remove old backups, compress the uncompressed, you use a batch file to call tidybackups then robocopy off to another server\nas or whatever.

  8. #7

    Join Date
    Sep 2011
    Posts
    162
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks all!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Exporting a report definition from SIMS
    By iceman in forum MIS Systems
    Replies: 30
    Last Post: 22nd May 2012, 02:59 PM
  2. [SIMS] XML spreadsheet from SIMS.net crashing??
    By ljlbray in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2011, 06:46 AM
  3. sims not enough space on drive
    By markcuk in forum MIS Systems
    Replies: 2
    Last Post: 10th June 2007, 05:15 PM
  4. Attendance figures from SIMS inconsistent
    By kingswood in forum MIS Systems
    Replies: 2
    Last Post: 8th June 2006, 10:28 AM
  5. Replies: 1
    Last Post: 9th May 2006, 05:56 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
  •