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...
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.
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.