-
1 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." -
2 full differential backup
"A backup of all files in the database, containing only changes made to the database since the most recent full backup. A full differential backup requires a full backup as a base." -
3 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." -
4 differential backup
A backup containing only changes made to the database since the preceding data backup on which the differential backup is based. -
5 partial backup
"A backup of all the data in the primary filegroup, every read-write filegroup, and any optionally specified files. A partial backup of a read-only database contains only the primary filegroup." -
6 full backup
A backup of an entire database. -
7 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." -
8 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." -
9 simple recovery model
"A database recovery mode that minimally logs all transactions sufficiently to ensure database consistency after a system crash or after restoring a data backup. The database is recoverable only up to the time of its most recent data backup, and restoring individual pages is unsupported." -
10 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." -
11 mirroring
"Immediately reproducing every update to a read-write database (the principal database) onto a read-only mirror of that database (the mirror database) residing on a separate instance of the database engine (the mirror server). In production environments, the mirror server is on another machine. The mirror database is created by restoring a full backup of the principal database (without recovery)." -
12 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." -
13 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." -
14 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."
См. также в других словарях:
Backup — For other uses of Backup , see Backup (disambiguation). In information technology, a backup or the process of backing up is making copies of data which may be used to restore the original after a data loss event. The verb form is back up in two… … Wikipedia
Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… … Wikipedia
Database dump — For information on obtaining the Wikipedia database, see Wikipedia:Database download. A database dump contains a record of the table structure and/or the data from a database and is usually in the form of a list of SQL statements. A database dump … Wikipedia
Database administrator — A database administrator (short form DBA) is a person responsible for the design, implementation, maintenance and repair of an organization s database.[1][2] They are also known by the titles Database Coordinator or Database Programmer, and is… … Wikipedia
Backup software — is a computer program used to perform a complete back up of a file, data, database, system or server. The back up software enables you to make an exact duplicate of everything contained on the original source. This software must also be used to… … Wikipedia
Database administration and automation — Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM DB2 and Microsoft SQL Server need ongoing management. As such, corporations that use… … Wikipedia
Backup Express — Infobox Software name = Syncsort Backup Express caption = developed by = Syncsort Inc. latest release version = 3.0 latest release date = September 2007 operating system = cross platform genre = backup license = Proprietary website =… … Wikipedia
Database management system — A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database… … Wikipedia
Backup (software) — Infobox Software name = .Mac Backup caption = .Mac Backup Screenshot author = developer = Apple Inc. released = latest release version = 3.1.2 latest release date = March 2, 2007 latest preview version = latest preview date = operating system =… … Wikipedia
Backup Domain Controller — In Windows NT 4 server domains, the Backup Domain Controller (BDC) is a computer that has a copy of the user accounts database. Unlike the accounts database on the Primary Domain Controller (PDC), the BDC database is a read only copy. When… … Wikipedia
backup — 1. noun a) A reserve or substitute. If the goalkeeper is injured, we have a backup. b) A copy of a file or record, stored separately from the original, that can … Wiktionary
