Microsoft SQL Server 2000 High Availability

F

failover clusters, 21172

advantages of, 81

Analysis Services and, 22425

applications and, 21920

availability technologies, comparing, 7880

backup and restore, 5078

clients , 66

Cluster Group configuration, 226

cluster nodes, 21416

compatibility issues, 224

components , 52021

database placement and, 123, 12526

defining, 53

dependencies, 22021

disaster recovery. See disaster recovery, failover clusters

disk array design, 13137

disk configuration, 1037, 21618

hardware-assisted backups and, 221

instances per cluster, 21213

IP addresses dedicated to, 21819

log shipping compared with, 7778

memory configuration, 22324

Microsoft.com case study, 528

Microsoft Exchange Server and, 22526

naming, 21314

network cards, 219

Network-Attached Storage and, 99

networking and, 599

planning for, 21112

ports, 219

previous implementations , 6264

replication compared with, 7778

server clusters configured as, 15657

service accounts and, 22223

SQL Mail and, 225

SQL Server and, 6466

third-party backup software, 509

validating, 189

Windows versions supported, 212

failover clusters, administering, 24460

cluster nodes, adding/removing, 24547

domains, changing, 25960

manually removing, 25156

renaming, 249

service failures and, 245

SQL Server Agent service accounts, changing, 258

SQL Server service accounts, changing, 25657

TCP/IP addresses, adding/changing/updating, 24849

tools for, 24445

uninstalling, 24951

failover clusters, disaster recovery, 26572

checkpoint files, lost or corrupt, 268

cluster database corruption on node, 267

cluster disk corrupt or nonfunctional, 271

cluster node failure, 26870

overview of, 26566

quorum corruption, 26768

quorum disk failure, 26667

when there is no backup, 27172

failover clusters, implementing

antivirus software, 229

Cluster Group thresholds, 24041

disabling unnecessary services, 233

disk drives , adding, 22932

installation order, 22728

installing virtual servers, 229

IPSec, 234

Kerberos, 23435

prerequisites, 227

resource failover preferences, 23740

resource ownership preferences, 23637

SSL certificates, 235

static port numbers , assigning, 23334

failover clusters, testing

applications and, 244

cluster node participation, 243

connectivity and name resolution, 24142

failover validation, 24243

service accounts and, 243

failover clusters, troubleshooting, 26065

cluster support and, 26162

connectivity problems, 26465

Full-Text Search resource types and, 265

installation problems, 264

log files, 263

MPS Reporting Tool, 263

problems, list of, 26061

process sequence, 262

Failure detection, 7879

failures. See damage assessment

FAT (file allocation table), 121

FC-AL (Fibre Channel-Arbitrated Loop), 145

Fibre Channel-Arbitrated Loop (FC-AL), 145

Fibre Channels

large cluster configurations and, 103

overview of, 1045

Windows servers using, 159

file allocation table (FAT), 121

file creation phase, database recovery, 48182

file-based backups

automating, 440

executing with Transact-SQL, 46265

filegroup organization and, 44041

frequency of, 440

pros/cons, 44344

recovering in place and up to the minute, 49095

filegroups

implementing, 12627

log shipping and, 29596

files

encryption, 645

@filename, 315

implementing, 12627

log shipping and, 29596

NTFS file system, 12122

permissions, 645

placement and protection of, 12327

replication, 354

shares, 22021, 539

size of, 12730

types of Windows system, 12122

filters, trace data, 721

fire suppression system, data centers, 23

firewalls, 165

firmware, 107, 538

::fn_trace_gettable, 719

fn_virtualfilestats function, 9697

ForceQuorum key, 19899

/ forcequorum switch, 198

formats, disk, 12223

fragmentation

logical vs. physical, 65455

monitoring, 72223

full database backups, 41822

conflicts with, 42022

costs of, 438

full database-based backup and, 435

log shipping and, 29394

overview of, 418

steps in process of, 41920

full database-based backup, 43538

automating backups, 435

example of, 43638

executing with Transact-SQL, 46061

frequency of backups, 435

pros/cons, 443

recovering in place and up to the minute, 48789

full file/filegroup backups, 42627

Full recovery model, 28384

comparisons with other recovery models, 4056

overview of, 408

when to use, 409

full-text indexes

log shipping and, 69

placement of, 125

replication and, 71

restoring, 57576

full-text searches

log shipping and, 28183

resource types, 265

Full-text support, 7980