R


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



Professional SQL Server 2005 Administration
Professional SQL Server 2005 Administration (Wrox Professional Guides)
ISBN: 0470055200
EAN: 2147483647
Year: 2004
Pages: 193

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net