-
1 log shipping job
"A job performing one of the following log-shipping operations: backing up the transaction log of the primary database at the primary server (the backup job), copying the transaction log file to a secondary server (the copy job), or restoring the log backup to the secondary database on a secondary server (the restore job). The backup job resides on the primary server; the copy and restore jobs reside on each of the secondary servers. See also: primary database, primary server, secondary database, secondary server." -
2 log shipping
"Copying, at regular intervals, log backup from a read-write database (the primary database) to one or more remote server instances (secondary servers). Each secondary server has a read-only database, called a secondary database, that was created by restoring a full backup of the primary database without recovery. The secondary server restores each copied log backup to the secondary database. The secondary servers are warm standbys for the primary server." -
3 log chain
"A continuous sequence of transaction logs for a database. A new log chain begins with the first backup taken after the database is created, or when the database is switched from the simple to the full or bulk-logged recovery model. A log chain forks after a restore followed by a recovery, creating a new recovery branch." -
4 transaction log file
"A file that contains a record of the changes that were made to an Exchange database. All changes to the database are recorded in the transaction log files before they are written into the database files. If a database shuts down unexpectedly, unfinished transactions can be restored by replaying the transaction log files into the database." -
5 secondary database
"In log shipping, a read-only database that was created by restoring a full backup of the primary database (without recovery) on a separate server instance (the secondary server). Log backup from the primary database is restored at regular intervals onto the secondary database." -
6 principal database
"In database mirroring, a read-write database whose transaction log is continuously sent to the mirror server, which restores the log to the mirror database." -
7 primary database
"In a log shipping, a read-write database whose transaction log is backed up at regular intervals for restoring onto one or more secondary databases." -
8 complete database restore
"A restore of a full database backup, the most recent differential database backup (if any), and the log backups (if any) taken since the full database backup." -
9 secondary server
"In a log shipping configuration, the server instance where the secondary database resides. At regular intervals, the secondary server copies the latest log backup from the primary database and restores the log to the secondary database. The secondary server is a warm standby server." -
10 full recovery model
A database recovery mode that fully logs all transactions and retains all the log records until after they are backed up. The database can be recovered to the point of failure if the tail of the log is backed up after the failure. All forms of recovery are supported. -
11 recovery
"A phase of database startup that brings the database into a transaction-consistent state. Recovery can include rolling forward all the transactions in the log records (the redo phase) and rolling back uncommitted transactions (the undo phase), depending on how the database was shut down." -
12 restore
"A multi-phase process that copies all the data and log pages from a specified backup to a specified database (the data-copy phase) and rolls forward all the transactions that are logged in the backup (the redo phase). At this point, by default, a restore rolls back any incomplete transactions (the undo phase), which completes the recovery of the database and makes it available to users." -
13 recovery model
"A database property that controls the basic behavior of backup and restore operations for a database. For instance, the recovery model controls how transactions are logged, whether the transaction log requires backing up, and what kinds of restore operations are available." -
14 quorum disk
"The cluster disk on which configuration data is maintained in the quorum log, cluster database checkpoint, and resource checkpoints. The quorum disk is managed by the quorum resource, which is usually a special kind of physical disk resource." -
15 primary server
"In a log shipping configuration, the server instance where the primary database resides." -
16 security-enabled workgroup
An Access workgroup in which users log on with a user name and password and in which access to database objects is restricted according to permissions granted to specific user accounts and groups.English-Arabic terms dictionary > security-enabled workgroup
См. также в других словарях:
Database Console Commands (Transact-SQL) — The Database Console Commands (DBCC) are a series of statements in Transact SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database.[1] These commands are also used to fix existing issues.[1] They … Wikipedia
log — ▪ I. log log 1 [lɒg ǁ lɒːg, lɑːg] verb logged PTandPP logging PRESPART [transitive] 1. to make a record of each time that something happens: • The new system logs every … Financial and business terms
Database tuning — describes a group of activities used to optimize and homogenize the performance of a database. It usually overlaps with query tuning, but refers to design of the database files, selection of the database management system (DBMS), operating system … Wikipedia
Database storage structures — Database tables/indexes are typically stored on hard disk in one of many forms, ordered/unordered Flat files, ISAM, Heaps, Hash buckets or B+ Trees. These have various advantages and disadvantages discussed in this topic. The most commonly used… … Wikipedia
Database audit — Database auditing involves observing a database so as to be aware of the actions of database users. Database administrators and consultants often set up auditing for security purposes, for example, to ensure that those without the permission to… … Wikipedia
Database security — concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links)… … Wikipedia
Log — Log, n. [Icel. l[=a]g a felled tree, log; akin to E. lie. See {Lie} to lie prostrate.] 1. A bulky piece of wood which has not been shaped by hewing or sawing. [1913 Webster] 2. [Prob. the same word as in sense 1; cf. LG. log, lock, Dan. log, Sw.… … The Collaborative International Dictionary of English
Log board — Log Log, n. [Icel. l[=a]g a felled tree, log; akin to E. lie. See {Lie} to lie prostrate.] 1. A bulky piece of wood which has not been shaped by hewing or sawing. [1913 Webster] 2. [Prob. the same word as in sense 1; cf. LG. log, lock, Dan. log,… … The Collaborative International Dictionary of English
Log book — Log Log, n. [Icel. l[=a]g a felled tree, log; akin to E. lie. See {Lie} to lie prostrate.] 1. A bulky piece of wood which has not been shaped by hewing or sawing. [1913 Webster] 2. [Prob. the same word as in sense 1; cf. LG. log, lock, Dan. log,… … The Collaborative International Dictionary of English
Log cabin — Log Log, n. [Icel. l[=a]g a felled tree, log; akin to E. lie. See {Lie} to lie prostrate.] 1. A bulky piece of wood which has not been shaped by hewing or sawing. [1913 Webster] 2. [Prob. the same word as in sense 1; cf. LG. log, lock, Dan. log,… … The Collaborative International Dictionary of English
Log canoe — Log Log, n. [Icel. l[=a]g a felled tree, log; akin to E. lie. See {Lie} to lie prostrate.] 1. A bulky piece of wood which has not been shaped by hewing or sawing. [1913 Webster] 2. [Prob. the same word as in sense 1; cf. LG. log, lock, Dan. log,… … The Collaborative International Dictionary of English
