MIS Systems Thread, SIMs Redundancy options in Technical; Hi I was wondering what mehods people use to make SIMs redundant/failover
I am currently running 1 sims server which ...
12th February 2009, 08:32 PM #1
SIMs Redundancy options
Hi I was wondering what mehods people use to make SIMs redundant/failover
I am currently running 1 sims server which is backed up every night to a DLT drive and the tape from the previous nights backup is taken off site.
I contacted capita today and was told that they are developing a redundant/failover system but it will be "some time" until its avaliable.
The best option I can think of that will not compromise my support contract is to purchase another server with a DLT drive and configure it with SQL2005 standard and SIMs and should a failure occur with the live server use the most recent backup tape to restore the SIMs.mdf and .ldf etc to the new server.
My problem with this arrangement is that It will take 4 hours + to restore.
assuming it fails during the working day. I would dearly like to have some kind of failover so that if the server fails the user will notice no loss of service giving me time to repair/replace the dead server while running from the hot spare.
Is anyone running such a system while still recieving support from Capita ?
The motivation for this is that we are nearing a time where parents will be able to view attendance data and acheivement data from SIMs via our VLE and as the VLE reads the data from SIMs I would like it to be as robust as possible...
Maybe I am asking too much !
12th February 2009, 09:02 PM #2
I have often wondered this myself - at present we have 1 server which is backed up by the LEA - at least we hope they are (saying they do and actually doing it are 2 differnt things)
Often wondered if we could "mirror" the sims server to another box....
12th February 2009, 09:02 PM #3
Forget the tape drive in the redundancy idea, have it (however often you want) synchronise the files over onto the second server over the network which will be a lot quicker than relying on a 4 hour restore.
I'm sure you could go even further with the whole process and have it nearer unnoticed but be aware you'll need more licenses for SQL Server likely and technically you should for SIMS.
12th February 2009, 09:07 PM #4
I do have have backup exec 12d on the sims server that will let me restore the database to a seperate server but this assumes that the database and the first server are avaliable.
when you say syncronize to another server what software method would you suggest ? I do understand the need for licences for SQL and sims its self
12th February 2009, 09:09 PM #5
Robocopy would do for you I'd imagine, mind you, getting hold of the ldf/mdf during normal operation may be a bit dramatic, maybe shadow volume copying ... oOo, I'm gaining an interest in trying this for myself now.
Thanks to kmount from:
soapyfish (12th February 2009)
12th February 2009, 09:12 PM #6
Cheers In will look at robocopy not tried it before maybe I can use it with the dbattach program to automate it ?
12th February 2009, 09:26 PM #7
Do you connect to the SIMs server hosted at the LEA or do they just handle the backups ?
12th February 2009, 09:26 PM #8
Well, if you only want to sync them at night you could script a back up with the SQL Admin manager or even harshly do a stop service back up in a sheduled task.
I'll have a think but I openly admit there's plenty more experienced folk on here who've probably done this, or at least took bold steps forward in sussing out some pitfalls.
12th February 2009, 09:30 PM #9
Yes I need to look into it very carefully as if cash is required then it will have to deliver all the expectations ! cheers again
12th February 2009, 09:31 PM #10
its managed by the LEA unfortunately.. I do have admin rights for the server though - well with a few restrictions here and thare but in general i have as close to Full rights as i can..
Originally Posted by soapyfish
12th February 2009, 09:34 PM #11
So if your server goes down its the LEA's responsibilty completly... that not entirely bad news
12th February 2009, 09:35 PM #12
Just seen post so no applicable really!
Last edited by RobFuller; 12th February 2009 at 09:41 PM.
12th February 2009, 09:38 PM #13
Yeah its over to the LEA - but Im their Human Shield when the firing squad break my door down!
Originally Posted by soapyfish
12th February 2009, 09:38 PM #14
We Currently have no virtulization at all and I did not think that capita would support that setup although I could be wrong is that something that you do ?
12th February 2009, 09:40 PM #15
Im wondering about setting up a 2nd server then trying to mirror the sql database over onto it and using rsync or a similar tool to copy the file structure across..
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