• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3051
  • Last Modified:

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

Tasks:
Active Directory
DNS
DHCP
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.
0
Fluid_Imagery
Asked:
Fluid_Imagery
  • 3
  • 3
  • 2
1 Solution
 
LauraEHunterMVPCommented:
> "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.  
0
 
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.  
0
 
LauraEHunterMVPCommented:
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.)
0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 
PlaceboC6Commented:
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.
0
 
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.
0
 
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.
0
 
PlaceboC6Commented:
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.

0
 
PlaceboC6Commented:
Did you have any further question?
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now