Term
| Draw a picture of the Log Shipping components. |
|
Definition
|
|
Term
| Log Shipping Scope: What feature does SQL Server offer to enforce referential integrity between related tables that exist in separate databases? |
|
Definition
| SQL Server cannot ensure that data will remain linked across databases. p.485 |
|
|
Term
| What are the three components of log shipping and what are their purposes? |
|
Definition
| The primary database is accessible and accepts transactions. The secondary database has a continuous chain of transaction logs applied to keep it up to date with the primary. The monitor instance sends alerts when the log shipping session is out of sync. p.487 |
|
|
Term
| What happens to log shipping if the recovery model is changed to Simple? |
|
Definition
| Since log shipping depends on transaction log backup, this change would cause log shipping to cease functioning. p.487 |
|
|
Term
| What affect would issuing a BACKUP LOG....WITH TRUNCATE_ONLY have on log shipping? |
|
Definition
| Since log shipping depends on transaction log backup, this change would cause log shipping to cease functioning. p.487 |
|
|
Term
| What are the two modes that a standby server can be in? |
|
Definition
| STANDBY Mode and NO_RECOVERY Mode. p.487 |
|
|
Term
Log Shipping operates at which level?
1. Instance
2. Database
3. Table
4. All of the above |
|
Definition
| Log Shipping operates at the database level. p.484 |
|
|
Term
| One sentence summary of Log Shipping. |
|
Definition
| continuously restoring transaction logs to a secondary database. p.489 |
|
|
Term
| What is the basic process for initializing log shipping? |
|
Definition
1. Create a share on both the primary and secondary because the backups need to be accessed across servers.
2. Create jobs to back up transaction logs, copy logs to the secondary, and restore the logs.
3. Restore a full backup to the secondary database.
4. Restore all subsequent transaction logs.
5. Start up jobs to automate restoration of the logs.
6. Copy any instance-level objects upon which the secondary database depends to service applications. p.489 |
|
|
Term
| How does SQL Server Agent interact with Log Shipping? |
|
Definition
| Log Shipping relies on jobs ran by SQL Server Agent. If agent is not running or the job is not running, Log Shipping is not running. p.490 |
|
|
Term
| What is the general rule of thumb for DATA LOSS EXPOSURE? |
|
Definition
| It should be twice the interval of the transaction log backups. If log backups are ran every 5 minutes, the data loss exposure is considered to be 10 minutes. p.490 |
|
|
Term
| How can Agent maintenance plans interfere with Log Shipping. |
|
Definition
| The backup job for log shipping replaces any existing transaction log against the primary database. You should change any maintenance plans that perform transaction log backups to exclude the primary database. p.492 |
|
|
Term
| Which type of backups do NOT affect Log Shipping? |
|
Definition
|
|
Term
| How can you transfer logins from onE instance to another? |
|
Definition
| SSIS has a task that can transfer logins from onE instance to another. p.493 |
|
|
Term
| Changing the primary database into which recovery model breaks log shipping? |
|
Definition
| Simple breaks the transaction log chain and does not allow transaction log backups to be executed. p.494 |
|
|
Term
| In Log Shipping, which components detect a failure and initiate a failover? |
|
Definition
| None. Detecting a failure and failing over are manual processes. p.505 |
|
|
Term
| SQL to recover the secondary database and enable it to start accepting transactions. |
|
Definition
| RESTORE DATABASE ... WITH RECOVERY. P.505 |
|
|
