+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SIMS: Backup and Recovery in Technical; Hi folks, I was curious about what others do for backup and recovery of SIMS. We use DPM 2010, and ...
  1. #1
    Gongalong's Avatar
    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    927
    Thank Post
    840
    Thanked 20 Times in 18 Posts
    Rep Power
    11

    Question SIMS: Backup and Recovery

    Hi folks,

    I was curious about what others do for backup and recovery of SIMS.

    We use DPM 2010, and I have no experience of SQL Server restores. At the moment DPM is set to backup SQL instances daily at 2am.

    Within the SQL instances there are several databases: model, master, Discover, msdb and SIMS. Is restoring the database as simple as just recovering the SIMS database from the list?

    Do others backup more frequently? (I'm guessing that DPM takes a shadow copy of the database, with respect to backing up a working database)

    Any information on this gratefully received.

    TIA

  2. #2
    Gongalong's Avatar
    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    927
    Thank Post
    840
    Thanked 20 Times in 18 Posts
    Rep Power
    11
    Just as a rider to this, our SIMS Administrator believes that previously she was able to restore SIMS to an hourly increment.

    We have reinstalled the SIMS server subsequent to my arrival at the school, and the backup strategy has changed.

    Would it have been possible to restore to an hourly increment by any other means than just backup?

  3. #3
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    981
    Thank Post
    38
    Thanked 178 Times in 143 Posts
    Rep Power
    96
    I use a Dbattach script to create a backup for the SIMS database each evening and use @matt40k 's tidy backup utility to zip and shrink these down. By using the Dbattach routine the passwords are passed to the Sims database as part of the process. I have not had any problems with recovering data either live at school request or into the test datacentre as a part of our DR testing.

  4. Thanks to Mcshammer_dj from:

    Gongalong (29th June 2012)

  5. #4

    Join Date
    Aug 2007
    Location
    Liphook
    Posts
    57
    Thank Post
    3
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    Ours is virtual so we use Veeam to replicate it to our disaster recovery server. When a user thought they had lost data a few months back I was able to quickly run up an old version of the server to look into the problem.

  6. Thanks to DarrenM from:

    Gongalong (29th June 2012)

  7. #5
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,958
    Thank Post
    969
    Thanked 463 Times in 390 Posts
    Blog Entries
    12
    Rep Power
    95
    Yeh same here, we virtualize it and backup the whole server.

    Also use backupexec to do the SQL each night.

  8. Thanks to zag from:

    Gongalong (29th June 2012)

  9. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by Mcshammer_dj View Post
    I use a Dbattach script to create a backup for the SIMS database each evening and use @matt40k 's tidy backup utility to zip and shrink these down. By using the Dbattach routine the passwords are passed to the Sims database as part of the process. I have not had any problems with recovering data either live at school request or into the test datacentre as a part of our DR testing.
    Same setup right here!

  10. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,890
    Thank Post
    751
    Thanked 1,467 Times in 1,219 Posts
    Rep Power
    364
    Daily full backup is the norm. I can't imagine you were doing full backups each hour, so the only other option would be to backup transaction logs each hour, but i've no experience of restoring them. I think the theory is you restore the most recent full backup then 'replay' the transactions. @jinnantonnixx would know

    I think it's a bit overkill, though i wont think that when i actually need it. For the most part, people want to look at data from the day before. If something is lost, it's not usually something that can't be re-keyed.

    There are little to no audit logs in SIMS, so narrowing down to when something was changed is a mammoth task, unless the user knows exactly, so replaying lots of transactions doesn't sound like fun, plus anyone that has entered data in that hour would lose work too.

    I prefer to restore a backup to a test server and look at or copy data out from there.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims Backup
    By squeeky in forum MIS Systems
    Replies: 45
    Last Post: 28th June 2012, 02:33 PM
  2. [SIMS] SIMS.net and multiple connect.ini files
    By NortyUK in forum MIS Systems
    Replies: 23
    Last Post: 9th September 2011, 01:05 PM
  3. [SIMS] SIMS .net and FMSSQL Autumn 2010 released!
    By matt40k in forum MIS Systems
    Replies: 5
    Last Post: 24th November 2010, 11:14 PM
  4. [SIMS] Sims backup regimes
    By creese in forum MIS Systems
    Replies: 6
    Last Post: 13th September 2010, 10:52 AM
  5. Backups and disaster recovery- newbie
    By s1mon321 in forum How do you do....it?
    Replies: 1
    Last Post: 4th August 2010, 10:21 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
  •