Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Cluster Active / Active SQL best practice

Active Directory, Domain, DNS, WINS, DHCP, SBS, New Releases.

Cluster Active / Active SQL best practice

Postby guest » Tue Nov 25, 2008 12:23 pm

you want to build a Cluster Active
/ Active SQL and want to know how to define the type of cluster and what
the best practice is.

According to my experiences, once we have built your Windows cluster,
ensure the following:

Check cluster disk resource group. You will need to add resource groups for
each SQL virtual server. For example, your default instance might need to
own disks D and E, while your named instance might need to own disks F and
G. Create these disk resource groups in advance to make sure they can move
around and will come online for all nodes.

For more information, we can refer to the following articles:
========================================
Active/Active clusters in SQL Server
http://searchsqlserver.techtarget.com/t ... 40,00.html

Building Active/Active SQL cluster-part1
http://busbar.maktoobblog.com/178241/Bu ... L_cluster-
part1

Best practice setup for Active-Active (Multi-Node) SQL Cluster and SAN
http://www.experts-exchange.com/Microso ... r/Q_231758
11.html

How do I setup a Active Active Cluster in Windows 2003?
http://www.experts-exchange.com/OS/Micr ... ver/2003_S
erver/Q_23113789.html

Server Cluster Overview
http://technet.microsoft.com/en-us/libr ... 59183.aspx

Note: This response contains a reference to a third-party World Wide Web
site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.
Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com

Troubleshooting Vista Wireless
http://chicagotech.net/
guest
 
Posts: 10191
Joined: Mon Nov 27, 2006 1:10 pm

Return to Windows

Your Ad Here

Who is online

Users browsing this forum: No registered users and 3 guests