+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, SIMS server reducancy in Technical; Our SIMS server just died and is currently waiting replacement parts (next day support contract, but the parts arnt in ...
  1. #1
    Newton's Avatar
    Join Date
    Oct 2007
    Posts
    179
    Thank Post
    59
    Thanked 5 Times in 5 Posts
    Rep Power
    14

    SIMS server reducancy

    Our SIMS server just died and is currently waiting replacement parts (next day support contract, but the parts arnt in stock!!!!)

    Its got me thinking is there away to have SIMS running on two servers so if one failes the end users dont notice?

  2. #2

    Join Date
    Apr 2008
    Posts
    853
    Thank Post
    111
    Thanked 112 Times in 108 Posts
    Rep Power
    45
    Virtualisation in HA mode

  3. Thanks to irsprint84 from:

    Newton (13th January 2011)

  4. #3

    Theblacksheep's Avatar
    Join Date
    Feb 2008
    Location
    In a house.
    Posts
    1,934
    Thank Post
    138
    Thanked 290 Times in 210 Posts
    Rep Power
    193
    Quote Originally Posted by irsprint84 View Post
    Virtualisation in HA mode
    Fault Tolerance.... Although it doesnt account for the storage, but you could offload entire copies of the VM each day to a seperate storage area.

  5. Thanks to Theblacksheep from:

    Newton (13th January 2011)

  6. #4
    Newton's Avatar
    Join Date
    Oct 2007
    Posts
    179
    Thank Post
    59
    Thanked 5 Times in 5 Posts
    Rep Power
    14
    Cheers this is a bit up the air at the moment, need to get the server working first, Log shipping sounds intresting, not something Ive herd of before.

  7. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    Quote Originally Posted by jinnantonnix View Post
    You could try SQL clustering. For this, though, you'll need shared storage.
    This is not supported by Capita, to the extent where I have been informed that it can actually cause issues with the SIMS DB as it changes Schemas and the like.

  8. #6
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Quote Originally Posted by localzuk View Post
    This is not supported by Capita, to the extent where I have been informed that it can actually cause issues with the SIMS DB as it changes Schemas and the like.
    Strange. Are you sure capita don’t support it?

    Our LEA run SIMS clustered over two powerful servers to host SIMS for all primary schools. They told me "the servers are set up identically but one is always run in passive mode and only kicks in if the other server goes down. As there is only one active server at any time you only have to purchase one SQL 2008 licence." They are capita supported.

    I looked into clustering when I set up my latest SIMS server but decided it was a bit over extravagant for a single secondary school, and I didn't really have the spare time to experiment/implement it. We already have a fair amount of redundancy via VMWare and 2 x SANS. In an ideal world though it would be a good idea to have two SIMS VM's clustered as you can virtually grantee no down time then.

    Butuz

  9. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    Ah, I seem to have forgotten I had been updated on this. There are instructions on how to do it on Supportnet in KB72633. http://support.capitaes.co.uk/websup...B72633.xmlTrue

    Remember though, that there is more to SIMS than just SQL. The document server would also need mirroring.

  10. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    It'll be wiser to go down the VM path rather then clustering. Capita support SIMS clustered, if it's done right.

  11. #9

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,625
    Thank Post
    49
    Thanked 460 Times in 336 Posts
    Rep Power
    140
    There is always Double-Take
    I have never used it myself as my mission critical SQL stuff is now hosted in Telehouse and failed over to Amsterdam by TicketMaster but it's commonly used to protect Access Control systems in mission critical environments such as Sporting Venues and Concerts where server failure is simply not an option.....

    Flash Demo Link
    Last edited by m25man; 13th January 2011 at 09:14 PM.

  12. #10

    Join Date
    Apr 2008
    Posts
    853
    Thank Post
    111
    Thanked 112 Times in 108 Posts
    Rep Power
    45
    in that case I have a VM template ready to go then do a data/ system state restore might not be instant but very low downtime

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMs Server Migration - Documents Server Issue
    By Andynonymous in forum MIS Systems
    Replies: 34
    Last Post: 29th May 2011, 07:16 AM
  2. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  3. Upgrading a SIMS.net Server from Server 2000 to 2003
    By PrimaryTech in forum Windows Server 2000/2003
    Replies: 8
    Last Post: 20th November 2010, 08:16 PM
  4. Replies: 5
    Last Post: 21st June 2010, 10:46 AM
  5. Sims server...
    By Dom_ in forum MIS Systems
    Replies: 15
    Last Post: 30th July 2009, 12:23 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
  •