RAID (Redundant Array of Inexpensive Disks), 21, 23, 27, 368–369
RAM, 354. See also memory
Raymond James Financial, upgrade evaluation for, 701–706
rbuildm.exe program, 64
real data type, 10
RECEIVE permission, for Service Broker objects, 257
RECEIVE statement, 232–233
RECONFIGURE command, 89–90
recovery of database. See backup and recovery
Red-Gate tool, 334
redo queue, for database mirroring, 550
Redundant Array of Inexpensive Disks (RAID), 21, 23, 27, 368–369
Relational OLAP (ROLAP), 202
remote connections, enabling, 39–40
Remote Desktop Connection, 31
remote installation, 30–34
replication
as alternative to clustering, 657
components of, 531
definition of, 529–530
jobs using, 106
log shipping integrated with, 648–649
merge replication, 530, 541
monitoring, 544–545
new features for, 530
peer-to-peer replication, 530, 542–544
snapshot replication
definition of, 530
distribution for, 532–534
publication for, 534–538
setting up, 531–532
subscribing to, 538–539
verification of, 539–541
support for, by SQL Server edition, 15
transactional replication
backup and recovery for, 606
compared to database mirroring, 585
definition of, 530
implementing, 541
types of, 530
Replication Management Objects (RMO), 545
Replication Monitor, 544–545
Reporting Services, SQL Server (SSRS)
configuring, 75
installation location of, 27
installing, 37–38
Scheduled Events and Reports Delivery, 75
uninstalling, 45–46
Web Services and HTTP Access, 75
Windows Integrated Security, 75
reports
Error Reporting, enabling, 78
log shipping as report database, 629
in Management Studio, 85–87
in SQL Server Upgrade Advisor, 60–61
support for, by SQL Server edition, 14–15
ReportServer application pool, deleting, 45
ReportServer database, dropping, 45–46
ReportServerTempDB database, dropping, 45–46
Resource database, 6
resources. See publications
RESTORE DATABASE statement, 620–621
RESTORE FILISTONLY statement, 600
RESTORE HEADERONLY statement, 601
RESTORE LABELONLY statement, 601
RESTORE VERIFYONLY statement, 599–600
restoring database. See backup and recovery
RMO (Replication Management Objects), 545
ROLAP (Relational OLAP), 202
role change
for database mirroring, 563–567
for log shipping
planned failover, process for, 644–645
redirecting clients, 646–647
switching between servers, 645–646
synchronizing dependencies for, 641–644
unplanned role change, process for, 645
role of DBA (database administrator), 1, 4
roles
accessing SQL Server Agent, 118–119
server roles, for SQL Server logins, 297
for SSAS, 206–210
for SSIS packages, 177
for users, 306
rollover trace files, 424
rotational latency, 364
routing, for Service Broker, 247–250
rows, maximum size of, 5
RS 2000
Report Server, 38