+ 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
    921
    Thank Post
    35
    Thanked 160 Times in 129 Posts
    Rep Power
    56
    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,011
    Thank Post
    82
    Thanked 184 Times in 153 Posts
    Rep Power
    68
    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,698
    Thank Post
    143
    Thanked 542 Times in 486 Posts
    Rep Power
    148
    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,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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,343
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    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
  •