+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, How long do you keep MIS database backups for? And how granular are they? in Technical; Here, I retain the daily backups for the current and previous month, any backups done on patch days for the ...
  1. #1


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,537
    Thank Post
    271
    Thanked 752 Times in 590 Posts
    Rep Power
    218

    How long do you keep MIS database backups for? And how granular are they?

    Here, I retain the daily backups for the current and previous month, any backups done on patch days for the current year and one backup per month for the last 12 months.

    We had an auditor (years ago) who wanted to see a snapshot of our data at a specific date, hence the habit of possible backup overkill.

  2. #2

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    21
    We don't retain data for more than a month. For recovery purposes we have daily backups and the thought of trying to reconstruct from a backup more than a few days old gives me nightmares (we keep 3 copies of daily backups in different places). SIMS retains historic data so we have that and older backups wouldn't run on the current SIMS version so I can't see any pnt in hanging on to old backups.

  3. Thanks to Hecate from:

    pete (12th February 2009)

  4. #3


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    Backups?! What are these?

    Er, we work on 6 months for weeklys and 2 weeks for daily's as well as Term tapes.

  5. Thanks to kmount from:

    pete (12th February 2009)

  6. #4

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    We have daily back-ups, and we just store them for about a month, and the delete them to make room for the next months worth

  7. Thanks to EduTech from:

    pete (12th February 2009)

  8. #5
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110
    4 daily, 4 weekly and monthly tapes going back to mid 2006

  9. Thanks to DMcCoy from:

    pete (12th February 2009)

  10. #6

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,666
    Thank Post
    119
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    My sims backups are full daily backups on a two week cycle. This backup includes the file backups of SIMS created by the upgrade process and manually by me when I patch the DB.

    These only go back to easter as that's when I put the new server in. I have all of them on the old server that I will archive when I decommissionthe old machine.

  11. Thanks to Stuart_C from:

    pete (12th February 2009)

  12. #7
    User3204's Avatar
    Join Date
    Aug 2006
    Location
    Wirral
    Posts
    769
    Thank Post
    55
    Thanked 66 Times in 62 Posts
    Rep Power
    33
    The trouble with SIMS data is that it rapidly goes out of date.

    I have 10 tapes, so this gives me 10 days (or two weeks), but I also have a scheduled backup to the NAS, so I end up wth duplicates (at another time of the day) on this, usually they're manually deleted once a month.



    I _want_ to get SIMS onto a VM machine, as according to VM Ware, it can do an hourly (for example) system backup.

  13. Thanks to User3204 from:

    pete (12th February 2009)

  14. #8


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,537
    Thank Post
    271
    Thanked 752 Times in 590 Posts
    Rep Power
    218
    Ok, so I am being over-cautious. Cheers guys.

    Having had an auditor ask to see a snapshot of the old (nt4, manky, crusty sims) sims server, I've always erred on the side of excessive backups.

SHARE:
+ Post New Thread

Similar Threads

  1. Backups
    By Gatt in forum How do you do....it?
    Replies: 8
    Last Post: 20th June 2008, 02:46 PM
  2. Backups
    By Alt in forum General Chat
    Replies: 6
    Last Post: 20th June 2008, 02:11 PM
  3. Backups
    By DSapseid in forum Wireless Networks
    Replies: 11
    Last Post: 12th March 2007, 10:54 AM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. Backups
    By Gatt in forum How do you do....it?
    Replies: 5
    Last Post: 5th February 2006, 11:44 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
  •