Term
| Mirror is always in a _______ state |
|
Definition
|
|
Term
| Mirror database, does not allow connections to be made to it or transactions written directly to it, so it _________ for backup instead |
|
Definition
|
|
Term
| data always flows from _________ to ________ |
|
Definition
|
|
Term
|
Definition
| Governs automatic failover. |
|
|
Term
| Witness is defined at the _______ level |
|
Definition
|
|
Term
|
Definition
| all db mirroring traffic is through a TCP endpoint with payload of DATABASE_MIRRORING |
|
|
Term
| DB Mirroring Endpoint, Security |
|
Definition
| default and recommended is to encrypt all |
|
|
Term
|
Definition
High Availability
High Performance
High Safety |
|
|
Term
| High Availability Mode, when the application commits a transaction, it goes to the ______ first |
|
Definition
|
|
Term
| for high availability, you need to have a _________ server |
|
Definition
|
|
Term
| All database mirroring traffic is transmitted through a TCP endpoint with a payload of _______ |
|
Definition
|
|
Term
|
Definition
| requires a principal, a mirror, and a witness for automatic failover. |
|
|
Term
|
Definition
| uses a principle and a mirror but does not have a witness so does not automatically fail over |
|
|
Term
|
Definition
no witness, no automatic recovery.
For a transaction to go through, it must first be committed on the witness. |
|
|
Term
| which mode is not recommended for normal operations |
|
Definition
| high safety because of the overhead. |
|
|
Term
| _____ and _____ recovery models are incompatible with Database Mirroring |
|
Definition
|
|
Term
| what level does database mirroring operate on? |
|
Definition
|
|
Term
| what is the process for preparing a database to participate in a Database Mirroring Session? |
|
Definition
| Change the recovery model to full, backup the primary database; restore the instance hosting the mirror db with the norecovery option; and then copy all system object such as logins linked servers, and so on |
|
|
