HP DL380-SL Guia do Utilizador descarregar pdf (Página 131)

Chapter 3: mx Commands 120

only if a higher-ranked node provides greater services than the backup node.

autofailback is the default.

[--application <application_name>]

The application tag associated with this Virtual SQL Server. If you do not

specify an application, the IP address for the Virtual SQL Server will be used.

[--msdtc]

Microsoft Distributed Transaction Coordinator (MSDTC) is used to

coordinate transactions between different SQL instances running on different

nodes in the cluster. There is one MSDTC service on each machine.

This option enables transactions that span one or more Virtual SQL Servers.

However, the following limitations exist when using a Virtual SQL Server

with MSDTC:

• Because only one MSDTC resource exists per machine, you can define

MSDTC support for only one Virtual SQL Server per machine. You can,

however, define other Virtual SQL Servers that do not support MSDTC.

• If two MSDTC-enabled Virtual SQL Servers share the same backup and

both Virtual SQL Servers fail, the first server to come up will lock the

MSDTC resource, preventing the other Virtual SQL Server from starting.

• You cannot use COM+ components or MSMQ on a node where MSDTC

has been virtualized.

For more information about MSDTC, see the MxDB for SQL Server

Administration Guide.

<ip> is the IP address for the SQL Virtual Server. <name> is the NetBIOS name

for this Virtual SQL Server; the name can include up to 15 characters.

The order in which you specify the network interfaces determines the

ordering for failover. The first network interface is the primary interface;

network traffic for the Virtual SQL Server goes to the node providing this

interface. The remaining network interfaces are backups. Each network

interface must be located on a different node.

delete—Delete a Virtual SQL Server

mx vsql delete <vsql>

1 2 ... 126 127 128 129 130 131 132 133 134 135 136 ... 140 141

Sem comentários

HP DL380-SL Guia do Utilizador Página 131