Index_R

R

RAID (Redundant Array of Inexpensive Disks), 13, 346

RAID 0, 13

RAID 1, 13, 210

RAID 5, 13, 210

RAID 10 (0+1), redundancy and performance, 13, 210

RAISERROR command, 137

RDBMS, upgrading to SQL Server from, 115

RDBMS (relational database management system), 115

Read-only databases, 41, 246-247

READ_ONLY keyword, 246

Read-only mode, placing a database in, 246-247

READ_WRITE keyword, 4, 246

Records

counting, 207-208

duplicate, 234

Recovery Interval option, 32

Recovery models, 42-43, 272

log shipping and, 348

and scaling up, 341

SQL Server, 43

Recovery options, 278

Redundancy, with RAID 10, 13

Redundant components, 345-346

Referential integrity

avoiding using triggers for, 227

for system tables, 458

Registry dependencies, 216-218

Registry entries, rebuilding, 217

Registry issues, 216

Registry key data items

caching, 125

creating, 495

deleting, 494

listing, 494-495

Registry keys

creating, 495

deleting, 493-494

determining existence of, 495

locking down, 82

permissions for, 82

reading and writing, 80-81

removing everyone group from, 82

Registry server listings, 217-218

Relational engine (SQL Server), 6

Remote Information screen, 404-405, 417

Remote servers, vs. linked servers, 301

Remote stored procedures, users who can execute, 467

Remote system monitoring, 140

Remove Files Older Than option, 353

Removing SQL Server, 14-15

Renaming a server, 27-28

REPAIR_ALLOW_DATA_LOSS option, 185

REPAIR_FAST option, 185

REPAIR_REBUILD option, 185

Replace Template Parameters option, 169, 171

replace() function, 193

Replication folder, permissions for, 434

Replication Merge object counters, 452

Replication Monitor (Enterprise Manager), 436, 452

Replication (SQL Server), 347, 419-454

agents connecting to publisher, 434

agents used in, 424

architecture of, 421-423

autonomy and latency, 424

column added to each table, 429

configuring after the wizard, 448-449

considerations, 420-421

customizing initial setup, 434-437

data type concerns, 430

disabling, 437

in disaster recovery, 453-454

distribution database location, 435

heterogenous support for, 423-424

identity columns and, 430-432

initial setup in Enterprise Manager, 432-437

list of servers participating in, 467-468

monitoring and troubleshooting, 452

optimizing, 454

preinstallation concerns, 429-432

problems when upgrading, 21

scenarios, 420

schema changes in, 449-451

types of, 424-429

Resolver priority code, 449

Resolver tab (Table Article Properties), 445

Resolvers (conflict), 445-446, 449

Resource group, configuring, 411-412

Resource group Properties dialog box

Failback tab, 411-412

Failover tab, 411

Resource state change sequence, 398

Resources (in clustering), 372

RESTORE command STOPAT parameter, 289

RESTORE DATABASE command, 284-286, 288

RESTORE DATABASE parameters, 285

Restore Database screen, 282-284

Restore Database screen Options tab, 283-284

RESTORE LOG command, 288

Restoring vs. attaching a database, 54

Restoring a database, 54, 282-293, 262

Restoring a large database, 262

Retina SQL Worm Scanner (E-Eye), 76

Revoking permissions, 61

right() function, 193

Rights to public role and guest account, 66

Roles in a database, listing, 476-477

ROLLBACK AFTER X SECONDS, 40

ROLLBACK IMMEDIATE command, 40

Rollback script, 54

Row size, 228-229

ROWGUIDCOL attribute, 430

Row-level security, 67-70

Rows (table)

finding the number of, 208

thin, 227