How to setup a Fail Over server - Server 2003 - AD / DNS / DHCP / SQL Server / File Server

We have a client that I'd like to have a fail over server setup for his current single server.  This is only a small office (10 computers).

Currently I have 2 server setup but not really in any sort of redundancy.  First server runs server 2003

Active Directory
SQL Server (specialized program)
File Server (just simple shares, user security etc)

2nd server is just running windows XP Pro and simply syncs the data over from the primary.  They just had the old server sitting around so I figured I'd do something with it.

I don't know if DFS or FRS is what I need to look into?  I've never set either of those up.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

> "2nd server is just running windows XP Pro"

That's not a server, as it's running a workstation operating system.  You would need to configure a 2nd 2003 server as an additional domain controller in your domain and as a 2nd DNS server to provide redundancy for those services; an XP box isn't going to cut it.  If your DNS is AD-integrated, it will replicate automatically once you have added a 2nd DC.  
Fluid_ImageryAuthor Commented:
Yeah we know how to do the secondary dns, ad, but as far as SQL and the files we are not to sure.

For files it would be DFS and DFS Replica right?

But what about SQL and the specialized program?

Reason for the 2nd box being XP is because they got a new server and we only had a spare XP key, so better then nothing, and 2nd backup of data is better then nothing.  
DFS replication will provide redundancy for file shares, but an XP workstation will not host a DFS-R replica. True fault tolerance option for SQL would be server clustering, which would require you to configure shared storage between the two servers (and would also require a server OS on the 2nd box.)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

I agree with Laura.   You need to buy a Server OS for the other server.  XP Pro is limited to 10 connections as well.  So even if you could make the DFS work with it,  you will not be able to connect more than 10 people to it.
Fluid_ImageryAuthor Commented:
The current machine will have Server 03 put back onto it.

What kind of setup is the clustering?  Any links for this kind of setup.
Fluid_ImageryAuthor Commented:
I realize that we will need to get a server 03 to start... I'm past that.  Once I get the server 03 configured with AD / DNS / DHCP (we already have that down)....

I need more help getting the proper way to setup the redudant SQL and redundant File Storage.
I'm not much of a SQL guy.

However as far as the file storage:

You can set up a domain DFS root and configure a target for matching shares on each file server.
You can enable replication to ensure the folders keep consistent with the same data.
In the event one server goes down,  users can still operate off the other one.

If you are using 2003 R2,  I suggest installing the second disk if you haven't already and use DFS-R instead of the old school DFS that 2003 RTM had.  If you have one R2 and one RTM,  you'll have to use DFS.

Did you have any further question?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.