Microsoft SQL Server 2000 High Availability

C

C2 security, 64546

cabling

allowing room for, 23

data center best practices, 2627

caching

disk, 11314

SANs and, 102

capacity planning, 8697

application database, 8893

deletes, 9193

disk space needed, 8788

high availability solutions, 514

indexes, 9091

inserts , 9193

monitoring, 724

overview of, 8687

physical disk performance, 9396

selects, 9193

SQL Server assisting with, 9697

updates, 9193

case sensitivity, database schema, 352

chain of command, disaster recovery, 554

challenge/defense protocol, 105

change management, 3548

development and, 3841

environments and, 3638

implementing, 4648

overview of, 3536

production and, 4145

change plan, 42

change request forms, 3738, 45

chargeback , upgrade costs, 584, 603

CHECKALLOC, 649

CHECKCONSTRAINTS, 649

CHECKDB, 64950

CHECKFILEGROUP, 649

checkpoint files

corrupt or missing, 268, 272

failover clusters, 5078

checkpoints, 387, 389

CHECKTABLE, 649

client transparency, 78, 80

clients

failover clustering and, 66

log shipping and, 69

network connectivity and, 176

replication and, 71

climate control

data center location and, 21, 23

disk drives and, 109

clones , 457

CLUSDIAG, 508

Clusrest.exe, 266

Cluster Administrator

failback settings, 23738

failover threshold settings, 23841

failover validation, 189, 24243

IP address changes, 19091

Kerberos, enabling, 182

MNS cluster, forcing quorum, 19899

MS DTC on Windows 2000 Server, 18487

MS DTC on Windows 2003 Server, 18789

name changes, 19091

network priority configuration, 18182

overview of, 244

preferred owner settings, 23637

server clusters, adding disks to, 19495

cluster command-line utility, 244

cluster database

corruption on node, 267

log files, 507

snapshot files, 507

cluster disk, corrupt or nonfunctional, 271

clustered indexes, 91

clustered servers. See server clusters

Cluster.exe, 191, 198

cluster-fixquorum command, 26667

cluster groups

configuration, 226

thresholds, 24041

virtual servers and, 58

cluster nodes

adding/removing, 24547

available for failover clusters, 21416

database corruption and, 267

disaster recovery and, 27172

failover verification and, 243

failure, 26870

Network Load Balancing, 58

overview of, 5455

service packs and, 630

SQL Server implementations and, 62

upgrades and, 616

virtual servers and, 5455

Cluster Service account

changing server cluster domain, 190

forcing quorum for MNS cluster, 199

overview of, 15960

Clustering API (application programming interface), 54

Cluster.log, 263

ClusterLogSize, 18283

clusters. See failover clusters; server clusters

CLUSTOOL, 508

Clustool.exe, 266

code reviews, 648

collations, SQL Server, 590, 6045

columns , database schema, 349

Comclust.exe, 184

Commerce Server, 549

communications

data center best practices, 2527

disaster recovery and, 554

DBA team, 3132

compatibility

availability technologies and, 73

failover clusters and, 224

log shipping vs. transactional replication, 76

server clusters and, 5354

completion states

NORECOVERY, 484

RECOVERY, 48384

STANDBY, 484

compression, 122

computer management, 122

configuration settings

documenting, 539

SQL Server 2000 upgrade and, 591

connectivity

domain connectivity, 278

encryption and, 64748

failover clusters and, 24142

troubleshooting, 26465

verifying network, 189, 64748

consolidation planning phase, SQL Server 2000 upgrade, 60611

migrating applications, users, and data, 6067

production server design, 606

risk assessment, 61011

testing processes, 60710

contact information, documenting, 537, 540

containers, 86

Content Management Server, 54950

contingency plans, 4243

contracts. See support agreements

convergence, Network Load Balancing, 58

costs. See budgets

counters

Sysperfinfo, 71418

System Monitor, 70912

CRM (customer relationship management), 9293

CustomDB1 server, 55152

CustomDB2 server, 55152

CustomDB3 server, 55152

customer relationship management (CRM), 9293

custom log shipping, 29697, 33940