Term
| what is the limiting factor for the speed of a backup |
|
Definition
| the performance of the device where the backup is being written |
|
|
Term
|
Definition
| built-in capability to create up to four copies of your backups |
|
|
Term
| what does INIT/NOINIT option do? |
|
Definition
control whether the backup is overwritten or appended to.
INIT = overwritten
NOINIT = appended to |
|
|
Term
| what does the CHECKSUM option do? |
|
Definition
| verifies the checksum before writing the page to backup |
|
|
Term
| what does the inactive transaction log contain |
|
Definition
| all changes that have been committed to the database |
|
|
Term
| what does the active transaction log contain |
|
Definition
| all changes that have NOT been committed to the database |
|
|
Term
| what is the name that is unique number assigned to every row in the transaction log |
|
Definition
|
|
Term
| what does a differential backup capture? |
|
Definition
| all changes since the last full backup |
|
|
Term
| what is the name of the special page in the header of a database that keeps track of all changes since the last full backup? |
|
Definition
| DCM (Differential Change Map) |
|
|
Term
| what's the difference between differential and incremental? |
|
Definition
| incremental backups are like transaction logs, they build upon each other, while differential all build from the last full backup. |
|
|
Term
| what option should you specify when you want to create a copy of a database but don't want to clear the transaction log or reset the differential change map? |
|
Definition
|
|
Term
| what option should you use when you don't want to backup any read only filegroups? |
|
Definition
|
|
Term
| what can you use to configure database backups and other DBA tasks? |
|
Definition
|
|
Term
| how do you make sure that a backup is usable |
|
Definition
| by using RESTORE VERIFYONLY |
|
|
Term
| during a restore, how do you make sure that the database doesn't go online immediately |
|
Definition
| you use the NORECOVERY option |
|
|
Term
| during restore, how do you make it so that the database recovers immediately |
|
Definition
| specify the RECOVERY option |
|
|
Term
| during a restore, what option do you want to use so that you can issue SELECT statements before the differential and incremental backups have been applied? |
|
Definition
|
|
Term
| during recovery, what option allows you to change the location of one or more data files when the database is restored? |
|
Definition
|
|
Term
| what is the first step you want to take during a recovery? |
|
Definition
| Backing Up the tail of the log |
|
|
Term
| How can you recover to only a specific point in time? |
|
Definition
| using a point in time restore, STOPAT, STOPBEFOREMARK, STOPATMARK |
|
|
Term
| what option could you use to enable a best effort restore |
|
Definition
|
|
Term
| what is a Database Snapshot |
|
Definition
a point-in-time read only copy of your database.
No Transaction Logs! |
|
|
Term
|
Definition
does not require a witness server
provides warm standby configuration
does not support automatic failover detection or automatic failover |
|
|
Term
| transparent client redirect |
|
Definition
| done in MDAC, Microsoft Data Access Components (MDAC) |
|
|
