+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SIMS Database in 'Full' Mode rather than 'Simple'? in Technical; Does anyone have their SIMS Databses set in 'Full' Mode? Allowing restores from the Transaction Logs? I can see the ...
  1. #1

    Join Date
    Dec 2011
    Posts
    15
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Database in 'Full' Mode rather than 'Simple'?

    Does anyone have their SIMS Databses set in 'Full' Mode? Allowing restores from the Transaction Logs?

    I can see the advantages of the 'Full' Mode but am unsure if it has any impact elsewhere? or if it is even supported by Capita?

  2. #2

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    We set all of ours to simple and use a .bak file to backup and restore.

    Full will allow your ldf to grow huge without a maintenance plan.

    It depends how granular you want to go with restores and how much time/space you have to throw at it. Our backup SLA is that we will restore from the previous day's backups.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,371
    Thank Post
    368
    Thanked 635 Times in 517 Posts
    Rep Power
    157
    Quote Originally Posted by Wayne_K View Post
    Does anyone have their SIMS Databses set in 'Full' Mode? Allowing restores from the Transaction Logs?

    I can see the advantages of the 'Full' Mode but am unsure if it has any impact elsewhere? or if it is even supported by Capita?
    Capita supports anything that works, that gives you a backup that you can restore from. They therefore recommend SIMPLE recovery mode and doing a FULL backup each day. If you only ever do a full backup - such as using dbAttach, I can't see why you would not want the recovery mode set to SIMPLE. Personally, I can do a full backup of a database in a few seconds and disc space isn't as much of an issue as it was so you could even do a full backup hourly! Admitting that'll be overkill, but at least you've got a simple recovery process, pick up file, restore, sorted.

    I know Attix 5 say you need to have it set to the FULL recovery mode, but then that takes care of truncating the log file so it doesn't fill your disc.

  4. #4

    Join Date
    Dec 2011
    Posts
    15
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Wayne_K View Post
    Does anyone have their SIMS Databses set in 'Full' Mode? Allowing restores from the Transaction Logs?

    I can see the advantages of the 'Full' Mode but am unsure if it has any impact elsewhere? or if it is even supported by Capita?

    Thanks for that Greg, we currently operate in the same manner but I was considering moving to 'Full' mode.

  5. #5
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    175
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    Quote Originally Posted by matt40k View Post
    Capita supports anything that works, that gives you a backup that you can restore from. .
    Whatever you use, do make sure that you regularly test restoring from backups. Otherwise you could find that the first time you find out it's not working correctly is when you actually need it.

  6. #6
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    908
    Thank Post
    92
    Thanked 118 Times in 95 Posts
    Rep Power
    46
    We did have our SQL server set to full, but it was using up 200gb of HDD space with the LDF, so we had switched to simple.

    We have a very comprehensive backup solution already, Full backups each night to tapes in the tapeloader and a batch file runs each night which backs up SIMS and FMS with the SIMS backup tools (cant remember its name off to top of my head but can check on monday) and then 2 hours later a batch file runs on a laptop (kept secure and encrypted with Truecrypt) which restores the database onto its own SIMS "server type" installation, so whenever the fire alarms sounds, the laptop is taken out, so if the worse case scenario every happens we can access information (up to a day old) that we can use on an emergency site (another local school) to get in contact with Parents and Staff and inform them of what is happening.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 10
    Last Post: 24th January 2012, 11:19 AM
  2. link in a php page sends the .php rather than the .pdf which is linked (ffox on Mac)
    By RabbieBurns in forum Internet Related/Filtering/Firewall
    Replies: 12
    Last Post: 31st July 2011, 12:01 PM
  3. Replies: 0
    Last Post: 18th January 2011, 12:42 PM
  4. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  5. [SIMS] Sims database structure
    By atfnet in forum MIS Systems
    Replies: 8
    Last Post: 12th October 2010, 10:13 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
  •