Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

how to create a mirrored server and switch over on one server failing windows server 2003 with sql server 2005 installed

Posted on 2007-11-28
5
Medium Priority
?
218 Views
Last Modified: 2010-04-18
Hi,

I have 2 windows 2003 server with sql server 2005 installed. I am trying to find out some information on how to mirror the two servers together in realtime and when the primary server fails the secondary kicks in.

I would appreciate your advice.

Best Regards
Lee
0
Comment
Question by:ljhodgett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 20364306
Database mirroring is a good (and cheaper) alternative to clustering for SQL server - see http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx and http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html for good "getting started" guides
0
 

Author Comment

by:ljhodgett
ID: 20364335
Hi,

Sorry I forgot to mention that the server has IIS 6 with an asp script that is used by multiple users so we want to mirror iis6 and all the users accounts hence I think it would be good if we can completly mirror the servers if possible.

Best Regards
Lee
0
 
LVL 70

Expert Comment

by:KCTS
ID: 20364366
If you want to mirror all aspects of the server then a cluster is your only option.
Your servers need to be running Windows Enterprise Edition with the necessary supported hardware - it not cheap - but it is effective - start at http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx
0
 

Author Comment

by:ljhodgett
ID: 20364858
Hi,

Does sound expensive but im afraid I can only have windows 2003 standard. Is there any other ways or suggestions how I can accomplish this.

Best Regards
Lee
0
 
LVL 70

Accepted Solution

by:
KCTS earned 2000 total points
ID: 20364887
Not really if you want to have complete server redundancy. SQL Mirroring and/or Log Shipping can provide an option to maintian high availibility of SQL but not other services.

The only other option I can think of is a product like doubletake - have a look and see if this will work for you http://www.doubletake.com/products/
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question