MIS Systems Thread, MIS Backup in Technical; Does anybody have a prefered solution for an MIS Backup system. We basically require a complete mirror of the MIS ...
16th February 2007, 03:08 PM #1
Does anybody have a prefered solution for an MIS Backup system. We basically require a complete mirror of the MIS system (which has not yet been implimented) so that should the serve containing the system fail, a secondary copy can be instantly activated. What is the easiest way to go about this?
IDG Tech News
16th February 2007, 04:44 PM #2
Re: MIS Backup
Symantec livestate: Create bare metal backup image which can then be built back onto any other server within minutes and hey presto. I think tests on 170Gb server rebuild from image file 15-20 mins max.
I think Acronis Server bare metal backup does much the same thing backup to nas server, set up the incremental function which will backup live data even SQL and keep it up to date so at anytime you can re-instate any server from anywhere.
Other than this buy another server of the same ilk and keep it updated from the other til needed if you want it immediately.
16th February 2007, 04:54 PM #3
Re: MIS Backup
Personally I don't like the idea of having a second "wasted" server to do this job. I would much rather have a NAS device backing up the MIS constantly and if the server running the MIS went down for anyreason, it wouldn't take very long to stuff it onto another server. Or even run the MIS data directly from a mirrored NAS. Can anybody help with an opinion of running from NAS that I can push onto SMT to get them to do it this way instead?
16th February 2007, 06:41 PM #4
- Rep Power
Re: MIS Backup
Then you two choices virtualisation or backip up data rather than a whole server state.
Originally Posted by tscnmuk
A constant backup of a live data base isn't possible. The most you can do is take periodic snapshots.
I would much rather have a NAS device backing up the MIS constantly and if the server running the MIS went down for anyreason,
Virtual Machines are best for rapid restore when you are restoring to disimilar physical hardware.
it wouldn't take very long to stuff it onto another server.
You haven't defined what kind of MIS your running do you mean just student/staff records database such as SIMS, CMIS, Integris,Bromcom etc or do you have other important systems do you wish to protect.
Or even run the MIS data directly from a mirrored NAS. Can anybody help with an opinion of running from NAS that I can push onto SMT
to get them to do it this way instead?
Most MIS systems run some king of SQL database and this normally needs to reside of the machine running the server software. So NAS is not feasible. Did you mean SAN (Storage Are Network). This would allow sepration of storage from processing.
The problem still remains of what to do about dissimilar replacement hardware if aren't willing to have a redundant standby server to hand.
It's either VM or hone your MIS software build procedure until you're like a Formula One pit crew changing tires
16th February 2007, 08:00 PM #5
Re: MIS Backup
We run CMIS with E-portal in our school, which has an SQL backend.
What we've done, rather than have a complete redundant system, is make the servers the MIS system relies on as fail safe as possible. They all have redundant drives, redundant power supplies, dual gigabit networking, and are all very new servers. We've set SQL to back up all our data to our storage server every 6 hours (could be more often, but we felt 6 hours was adequate) which then in turn gets backed up to tape every night, so there's always plenty of current copies of the SQL data available in the event of a failure.
Hopefully it'll never happen, but in the event of our SQL or MIS server failing, we could have it back up on another box within a short period of time, probably less than 2 hours, possibly as short as an hour. Testing our disaster recovery procedures is on the cards in the near future so I guess we'll find out!
By ozzy in forum How do you do....it?
Last Post: 19th December 2007, 03:47 PM
Last Post: 20th September 2007, 10:16 PM
By robknowles in forum Hardware
Last Post: 18th April 2007, 10:55 PM
Last Post: 1st August 2006, 10:25 AM
By ChrisH in forum Scripts
Last Post: 20th October 2005, 01:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)