R

RAID

Redundant Array of Inexpensive Disks. A RAID array uses multiple physical disks to simulate one logical, larger disk, often with protection from disk failure. (The I can also stand for Independent, and the D can also stand for Drives.)

RDL

Report Definition Language. A programming language used to describe a report in SQL Server Reporting Services.

RDMS

A type of database management system (DBMS) that stores data in the form of related tables. It stands for Relational Database Management System.

Recovering mode

When a database is being restored from backups and there are additional log backups to be applied, the database is in a recovering mode and inaccessible during this time by default. The STANDBY option used with the restore command will allow read-only access to the database in this state.

RECOVERY option

An option to the T-SQL command RESTORE DATABASE that recovers any transactions and allows the database to be used. This is the default if no options are specified.

Referential integrity

Relational database integrity that dictates that all foreign key values in a child table must have a corresponding matching primary key value in the parent table.

Relationship

A social association or connection between two or more people.

Replication

A set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

Replication topology

The different roles played by various SQL Server instances in a replication solution.

Report model

A semantic description of business entities and their relationships in a SQL Server Reporting Services solution. Used to create ad hoc reports through the Report Builder application.

A SQL Server technology that can automatically send data modifications made to a database to other databases located on separate SQL Server instances or other heterogeneous database engines.

Report Builder

A SQL Server 2005 utility used in SQL Server Reporting Services to build ad hoc reports.

Report snapshot

A SQL Server Reporting Services report that contains data that was queried at a particular point in time and has been stored on the Report Server.

ReportServer

A system database used by SQL Server Reporting Service to store report definitions, data sources, schedules and delivery information, security information, and snapshots and snapshot history

ReportServerTempDB

A system database used by SQL Server Reporting Service to store temporary Reporting Services information

REVERT

A Transact-SQL statement that returns the execution context of a Transact-SQL batch to the previous calling principal.

REVOKE

A Transact-SQL statement that revokes/removes a granted object or statement permission.

Role

A SQL Server security account that is a collection of other security accounts that can be treated as a single unit when managing permissions. A role can contain SQL Server logins, other roles, and Windows logins or groups.

Roll back

To reverse or undo changes made so far.

Rowsets

OLE DB objects that contain result sets.

Run book

Logs all actions taken by a database administrator that affect production databases. This includes anything that modifies the database or server configuration and any specific changes, based on user requests, made to data.