|
|
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
|
|