Index_R

R

racks, server organization, 2223

RAID (redundant array of independent disks), 11419

Direct-Attached Storage and, 98

disk redundancy with, 381

documenting, 538

failover clusters and, 221

hardware vs. software, 119

mirrored stripes , 11617

mirroring (RAID 1), 115, 13337, 390

MNS clusters and, 158

Network-Attached Storage and, 99

overview of, 114

page files and, 672

striped mirrors, 11516

striping, (RAID O), 114, 449

striping with parity (RAID 5), 11719, 13337, 523

transaction logs and, 390

RAISERROR, 384

random I/O, 112

raw disk space, 8788

readahead I/O, 112

read-only access, 27475

read-only database, 4344, 6869

read-only SQL Servers, 2056

read-only tables, 441

read/write statistics, 723

read-write tables, 441

REBUILDM command-line utility, 125

reconstruction, 56365

recovery. See also backup and restore; disaster recovery

paths, 436

up-to-the-minute recovery, 442

Windows Server 2003 enhancements, 155

RECOVERY completion state, 48384

recovery models, 40416

Bulk-Logged recovery model, 40912

choosing, 4078, 41314

Full recovery model, 4089

functions of, 406

log shipping, 28385

overview of, 4046

settings, 400

Simple recovery model, 41213

switching between, 41416

tail of the log and, 407

redo phase, database recovery, 483

redundancy. See also RAID (redundant array of independent disks)

backup strategies and, 443

booting Windows from SANs, 145

prevention and, 45

registry

page files, 67172

permissions, 645

Registry Editor, 259

release readiness review, 45

Remote Administration mode, Terminal Services, 147

Remote Distributor, 35657

remote mirroring, 11920

remote procedure calls (RPCs), 165

remote sites, 536

replication, 34577

agents , 35355

architecture, 352

database availability and, 34546

database schema and, 34852

database synchronization and, 517

disk capacity and, 36063

distribution database and, 12425

Distributors and, 35658

failover clusters compared with, 7778

file types, 354

logins and, 348

log shipping and, 7477, 37275

merge replication, 346

overview of, 6971

primary database and, 278

Publishers and, 35658

Republishers, 35859

role changes and, 37577

service packs and, 360, 63334

snapshot replication, 347

transactional replication, 7477, 34748

upgrades and, 6012, 618

replication, disaster recovery, 36372

backing up replicated database, 36465

Distributors, 366

overview of, 36364

Publishers, 36566

scenarios, 37072

Subscribers, 36769

sync with backup option, 36667

system databases, 36970

Replication folder, Enterprise Manager, 364

reporting server, 522

reports , monitoring

baseline, 702

overview of, 69697

sample, 700701

Republishers, 35859

requirements set, high availability solutions, 51516

resources

failover clustering and wasted , 67

failover preferences, 23740

management, 681

ownership preferences, 23637

restore. See backup and restore

RESTORE, 48586

RESTORE FILELISTONLY, 47778, 487, 498

RESTORE HEADERONLY, 451, 476

RESTORE LABELONLY, 476

RESTORE VERIFYONLY, 478

retention period, backups , 43334, 553

risk assessment, 54253

BizTalk servers, 54849

Commerce Server, 549

Content Management Server, 54950

CustomDB1, CustomDB2, and CustomDB3, 55152

database dependencies, 54549

database inventory, 54445

environment inventory, 54243

instances of SQL Server, 543

list of risks and unknowns, 55253

servers, 552

software inventory, 543

upgrades, 61011

risk identification, 910

role changes, 31116

demoting primary, 31113

options for, 290

performing, 33538

promoting secondary, 31315

replication and, 37577

switching back to primary, 278

types of, 335

Role Removal Confirmation wizard page, 151

roles

disaster recovery, 558

schema design, 648

rollback strategies, 4243, 47

rollout, 4647

rotation, DBA team, 31

rotation of backup media, 433, 499

routers, documenting, 539

routine maintenance commands, 64950

rows, database schema, 349

RPCs (remote procedure calls), 165

run book

Analysis Services administrative information, 537

application system information, 537

database component information, 538

defining, 49

list of other information in, 54041

network information and configuration, 539

overview of, 53435

reconstruction and, 564

server configuration information, 538

SQL Server administrative information, 53537

SQL Server configuration information, 53839

storage information and configuration, 53940