Avatar of jerlejeune
jerlejeune
 asked on

Server Redundancy Simplified

I am purchasing two new servers with the objective of mirroring the servers for redundancy and fail safe should one go down.

with only 20 employees using simple applications and one SQL based application, i am looking for the easiest most straight forward setup possible.

will be using server 2008 on a domain. no vlans. small budget.
Microsoft Legacy OS

Avatar of undefined
Last Comment
Lee W, MVP

8/22/2022 - Mon
ndr-itsolutions

What applications are you using ?
Do they store data on the server ?
Is user data to be stored on the server ?
What version of SQL are you using ?

At the simplest level, some power shell scripts could take of SQL and file replication.
jerlejeune

ASKER
basic office programs.
files and proprietary software stores data on the server.
no user data stored. no roaming profiles.
SQL server 2008
ASKER CERTIFIED SOLUTION
ndr-itsolutions

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Lee W, MVP

Understand, the more redundancy you want, the more expensive it generally is.  Backup is simple.  REDUNDANCY on the level I think you want is NOT and it's generally expensive.

That said, since you are virtualizing (right?  You ARE virtualizing?  You wouldn't be installing directly to the hardware and wasting all those resources!)  if you virtualize with Hyper-V, Hyper-V offers a feature called Hyper-V Replica in 2012.  When setup (AT NO ADDITIONAL COST) it creates a replica of a server and keeps it updated to within 5 minutes of the primary server.  If the primary server fails, you have lost, at worst, 5 minutes of data.  (This is NOT a substitute for backup since a deleted file on one is a deleted file no more than 5 minutes later on both).  And the replica will come up dirty (as in thinking you just pushed the power button and didn't properly shut down).
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck