Index_A

A

access control lists (ACLs), 243

account passwords, 64041

ACLs (access control lists), 243

active/active clustering, 6263

active/passive clustering, 6263

addresses, failover clusters, 24849

Address Windowing Extensions (AWE), 66870, 678

administration, 63990

application security, 64649

database configuration, 657

database corruption, 656

defragmenting indexes, 65354

defragmenting VLDBs, 65556

DTS package transfers, 68990

failover clusters. see failover clusters, administering

files and filegroups, 126

logical vs. physical fragmentation, 65455

login transfers between instances, 68289

login transfers to standby, 681

maintenance, 64953

memory. see memory

object transfers between instances, 68289

object transfers to standby, 681

resource management, 681

server clusters. see server clusters, administering

server security, 64046

SQL Server 2000 upgrade and, 6023

user transfers to standby, 681

user transfers between instances, 68289

affinity mask option, 59798

alerts

automating data collection, 713

configuring for file size , 129

setting up, 704

SQL Server, 7067

transaction log backups , 46971

ALTER DATABASE Transact -SQL command, 128

Analysis Services, SQL Server 2000

administrative information in run books, 537

cluster awareness and, 22425

antivirus software

failover clusters and, 229

server clusters and, 166

API (application programming interface), 54

application programming interface (API), 54

applications

compatibility with database instances, 595

database, 8893

dependencies, not configuring as, 22021

deploying, 612

failover capability, 21920

failover clustering and, 66, 244

log shipping and, 69, 28890

replication, 71

run books and, 537

security, 64649

upgrades, 618

arbitration process, 105

architecture

disk subsystem, 595

hardware, 111

high availability, 51819

replication, 352

security, 537

ASR (Authoritative System Restore), 501

attaching/detaching databases, 62224

attacks, 531

auditing

data center security, 25

events with SQL Profiler, 645

production change plan, 42

authentication

application security and, 64647

log shipping and, 293

types of, 641

Authoritative System Restore (ASR), 501

authorization, 2425

autogrow settings, 12829

Automatic Recovery, 38889

Automatic switch to standby, 7879

automating backups, 46672

alerts, 46971

preventing human intervention errors, 501

schedule for, 46669

time interval criteria, 467

transaction log backups, 46769

automating collection of data, 71214

AUTO_SHRINK property, 130

availability, 51332

assessing, 1516

architecture, 51819

barriers to, 18

calculating, 1011

conditions and constraints, 51415

cost of, 1617

customers and, 1617

defined, 4, 8

documentation, 49

guiding principles of, 78

nines, 1012

reporting server, 522

AWE (Address Windowing Extensions), 66870, 678