server backup or redundant?

we just took over an office that runs its accounting on an sqlbase server(?).  several office computers access the same files and software at the same time so im guessing this is where it all takes place.
is there a better way of running this setup today?
main concern is the office shutting down if this old box (see pdf file attached) dies.  how can we set up another box that mirrors this one so it will take over if the the old one dies?  thanks and im sure I will need to elaborate as this thread evolves :-)
Who is Participating?
kode99Connect With a Mentor Commented:
It is highly likely that the accounting software is tied to this SQLbase,  meaning that you will not be able to migrate to anything else without also migrating the whole accounting software package as well.  

The good news is that you can probably talk to the company that provides the accounting software to figure out what the options are.  You may be able to upgrade to the latest SQLBase version 11,  which does support Win7 or you may have other alternatives for a data server with their software.  It is possible that you would need to upgrade to the latest version of the accounting software which may include the SQLBase update.  

I do not thing you can do an actual fail over with SQLbase but it may be possible.  The best alternative may be to do automated backups of the data and be

Here's the info for the SQLBase,  but this is a developer product and Gupta may not support end users directly,

The version 9 does list support for WinXP.  The most immediate thing may be to simply have a 2nd machine prepared and do good backups.  There should be an admin tool on the data server which would allow you to run scheduled live data backups.  So you could do daily or hourly backups while everything is up.

"P2V it and run as a VM?"
This is just geek speak P2V = Physical to Virtual.  There are tools available to essentially copy a server setup into a virtual configuration.  This virtual configuration or VM aka Virtual Machine,  is then run on a modern server using software that emulates the hardware that your server would need to run.  The virtual machine runs in its own instance with no direct knowledge of the actual hardware or OS of the server that hosts it.  You can do things like run a win2000 instance on a linux server or run linux instance on a windows system etc.

Because the current hardware often far exceeds the performance needed for old systems this is often a good way to maintain old software that would otherwise not work on a modern OS version directly.  

I think leew's advice about hiring help is likely the step you should take after talking with the accounting software company.  For right now make sure that things are being backed up every night - to something other than just the drive on the server,  possibly an external drive or another server (or both).

You are right to be concerned.  Getting drivers for win2000 for modern hardware is a problem and you do need a plan.
Migrate to a new MS SQL server?
In the meantime, if hardware is the issue it doesnt seem to be super resource intensive.

P2V it and run as a VM?

Here is a link for 9.0.1 and under migration to SQL.
StewartGilliganAuthor Commented:
oh my im over my head.  I was hoping there was some setup on xp or win7 that could run this same setup since I know nothing of sql :-(  p2v? vm? migrate?  I don't even know what sql is :-(.  
I guess I should focus on a machine that will take over if this one fails??  how can that be done?
Lee W, MVPTechnology and Business Process AdvisorCommented:
If you feel you're over your head, then you need to hire someone to take care of this for you - subcontract if you need.

That said, SQL Databases do not "fail over" well because the data must be in sync in both places.

One solution is to setup a virtual cluster.  This can protect against hardware failure, but will not protect against OS failure.  But if you don't have experience with this, then you will need help with that.  Either way, it sounds like you need expert help and a few words of advice here won't necessarily get these things working for you.  We can help guide you to a plan... but implementation needs to be done right.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.