Shared Flashcard Set

Details

DBA, Chapter 16
Log Shipping
6
Computer Science
Undergraduate 4
03/30/2011

Additional Computer Science Flashcards

 


 

Cards

Term
log shipping, sends to the secondary server as soon as _______
Definition
the log is backed up
Term
to synchronize during failover, backup the ______ table in the master db to a text file
Definition
syslogins
Term
WHat is the potential data loss exposure in Log Shipping?
Definition
Twice the interval of the transaction log backup
Term
set backup, copy, and restore jobs in the same ______
Definition
interval
Term
What is the most important point of failure for Log Shipping
Definition
SQL Server Agent
Term
DDL triggers at the instance level must be recreated on the ______
Definition
secondary
Supporting users have an ad free experience!