+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 38 of 38
MIS Systems Thread, SIMs Redundancy options in Technical; We have a cheap and cheerful solution. We have a decent laptop with a parallel SIMS install running on it ...
  1. #31

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29
    We have a cheap and cheerful solution. We have a decent laptop with a parallel SIMS install running on it on 2003 server. As part of our backup routine the sims database files are copied each night to various places on our network. First thing in the morning we plug the laptop into the network and a scheduled task uses dbattach to attach the copy of the database into the parallel system. The laptop goes home with myself or my network manager every night.

    This gives us a fuly working SIMS server that can be set up off site if needs be; in desperation we could quickly build an ad-hoc network with staff laptops to get several people into the system; obviously we would lose a days changes but this is a small price to pay if you are planning for a major disaster where you do not have access to the site or any of the computers in it. In the bag with the laptops is a small switch and a car power supply and various leads, and we reckon we could run SIMS in the car park for several hours if needs be.

    Its not instant fallover, but it cost a few hundred pounds for the hardware and the additional licences on our Schools Agreement.

  2. #32


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,706
    Thank Post
    354
    Thanked 807 Times in 722 Posts
    Rep Power
    348
    How have you secured the laptop? (Encryption of sorts?)

  3. #33

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,529
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    Quote Originally Posted by SYNACK View Post
    Why not use the built in replication features of SQL server just set the backup server as a replication subscriber to your primary server and set it to transactional replication which will keep it up to date as the data changes.

    SQL Server Replication
    How to Configure SQL Server Site Database Replication

    Given that it is a simple one way replication handled entirely in the background by SQL it should not cause any issues with the SIMS software and so hopefully they would still support it.
    Doing this is not supported by Capita, as it changes the DB Schema (there is a comment from one of their staff on the Capita SupportNet forums about it).

  4. #34

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29
    Quote Originally Posted by kmount View Post
    How have you secured the laptop? (Encryption of sorts?)
    Encrypted hard drive - it needs a usb key to boot it.

  5. #35

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,260
    Thank Post
    290
    Thanked 796 Times in 605 Posts
    Rep Power
    348
    One thing I haven't seen mentioned is the Document Server storage folder, which you will need to get a fully working SIMS! Please check you are backing this up as its outside of the SIMS Root folder.

  6. #36
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,067
    Thank Post
    69
    Thanked 81 Times in 64 Posts
    Rep Power
    36
    Quote Originally Posted by teejay View Post
    One thing I haven't seen mentioned is the Document Server storage folder, which you will need to get a fully working SIMS! Please check you are backing this up as its outside of the SIMS Root folder.
    I was thinking the same thing. The docstore and the DB need to be treated as a matched pair.

    HBJB

  7. #37
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,505
    Thank Post
    10
    Thanked 508 Times in 445 Posts
    Rep Power
    116
    It's also suggested that the sims and fms databases are now restored at the same time when the salary projections are linked in personnel 7.

    "If you are using Personnel 7.86 or later to generate Salary Projections in FMS and you need to restore your SIMS .net database, you must restore your FMS system to the same point. This will ensure that Salary Projections are calculated accurately and consistently. It is recommended that a backup of both databases is always taken at the same time to facilitate this."

  8. #38

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    You can run SIMS on a load balanced MSSQL server, the files can go on a SAN, DMS is the only single point of failure, which you would have to manually fallover. I suppose because it's a HTTP server you could do it that way, again files on a SAN.



SHARE:
+ Post New Thread
Page 3 of 3 FirstFirst 123

Similar Threads

  1. Virtualisation Network Redundancy
    By saundersmatt in forum How do you do....it?
    Replies: 1
    Last Post: 3rd March 2009, 05:28 PM
  2. Redundancy for printers
    By Maximus in forum Wireless Networks
    Replies: 6
    Last Post: 12th February 2009, 09:07 PM
  3. DHCP Redundancy
    By boomam in forum Wireless Networks
    Replies: 23
    Last Post: 4th February 2009, 01:32 PM
  4. Replies: 17
    Last Post: 25th October 2007, 09:03 AM
  5. failed redundancy - what to do?
    By browolf in forum Hardware
    Replies: 3
    Last Post: 2nd November 2005, 09:59 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •