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 ...
13th February 2009, 08:46 AM #31
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.
13th February 2009, 08:48 AM #32
How have you secured the laptop? (Encryption of sorts?)
13th February 2009, 09:16 AM #33
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).
Originally Posted by SYNACK
13th February 2009, 10:57 AM #34
Encrypted hard drive - it needs a usb key to boot it.
Originally Posted by kmount
13th February 2009, 11:11 AM #35
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.
13th February 2009, 11:25 AM #36
I was thinking the same thing. The docstore and the DB need to be treated as a matched pair.
Originally Posted by teejay
13th February 2009, 11:31 AM #37
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."
13th February 2009, 12:10 PM #38
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.
By saundersmatt in forum How do you do....it?
Last Post: 3rd March 2009, 05:28 PM
By Maximus in forum Wireless Networks
Last Post: 12th February 2009, 09:07 PM
By boomam in forum Wireless Networks
Last Post: 4th February 2009, 01:32 PM
By Adam_C in forum MIS Systems
Last Post: 25th October 2007, 09:03 AM
By browolf in forum Hardware
Last Post: 2nd November 2005, 09:59 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread