SQL Virtual Server Components

j File View Window Help

JflJxj

1

è

X

É'

i

i-~

S !S| TNI02CLU5 B LH Groups

Cluster Group a ffil'B

: - 5QLDB2 Q Resources B LJ Cluster Configuration ■ Q Resource Types 0"{_J Networks

_I Network Interfaces

-¿J 710DNODEA O Active Groups LJ Active Resources ■{j Network Interfaces B^jj 7IOONODEB

■jj Active Groups LJ Active Resources _I Network Interfaces

For Help, press Fl

Name

I State

Diste Online

^jjMSDTC Netw'orkN,,. Online llJMSDTCIPi Online

(ÜSQLSRVl IP Address Online

(jjSQLSRVl Network,,, Online JJ5QLSRV1 5QLServ... Online JJSQLSRVl SQL'Serv,,, Online

(jjSQLSRVl VServer Online

71ÜONODEB 71ÜONOCJEB 7100NODEB 7100NODEB 7ÍOONODEB 7100NODEB 7100NODEB 7100NODEB

Resource Type Description

Physical Disk Network Name IP Address IP Address Network Name 5QL Server 7,0 5QL Server Age,,, Generic Service

Resource Name for..

Microsoft Distributed Transaction Coordinator

Microsoft Distributed Transaction Coordinator (MS DTC) supports distributed updates in an application. This is the only way to guarantee tight consistency (all copies of your data always have the exact same data values at the exact same time) and that the data is in a state that would have been achieved had all the work been done at one site. SQL Server ships with the MSDTC service, which allows for this tight consistency, with real-time updates.

General Dependencies | Advanced ] m SQLSRV1 SQL Server 7.0

Specify which resources.the Cluster Service must bring online before this resource can be brought online.

Resource dependencies:

N ame

Resource T l'pt

Im Cd :

Pbysical i}¡sk

IjjSQLSRVÍ VS erver

Séneric Service

•An example of SQL l FailOver capability

3L

In order to perform a smooth and successful installation of SQL 2000 in a Cluster Environment you must:

•Ensure the cluster is operating properly with a shared disk resource available for data (i.e. Disk W:)

•Before beginning SQL Server setup run the comclust command on each node

• Creates an MSDTC resource (Microsoft Distributed Transaction Coordinator) in the Cluster Group

•Create a SQL Group in the cluster. Move the Disk Resource that will hold the SQL data files into the SQL Group.

•Start the SQL Server setup on the node which currently owns SQL Group

•Create a new instance of SQL Server on a Virtual Server

Configure an IP address on the client network for the Virtual SQL Server

Create the SQL data files on the shared disk resource (W:)

SQL Server setup will automatically install the code on the local drives of the server nodes and create the required cluster resources.

Was this article helpful?

0 0

Post a comment