Shared Flashcard Set

Details

SS 2008 16 Log Shipping
SQL Server 2008 - Implementation & Maintenance
17
Software
Undergraduate 1
06/08/2013

Additional Software Flashcards

 


 

Cards

Term
Draw a picture of the Log Shipping components.
Definition
[image]
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
Full and differential.
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
Supporting users have an ad free experience!