Shared Flashcard Set

Details

DBA Chapter 9
Backing Up and Restoring a Database
24
Computer Science
Undergraduate 4
03/22/2011

Additional Computer Science Flashcards

 


 

Cards

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
The MIRROR TO Clause
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
LSN, Log Sequence Number
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
COPY_ONLY
Term
what option should you use when you don't want to backup any read only filegroups?
Definition
READ_WRITE_FILEGROUPS
Term
what can you use to configure database backups and other DBA tasks?
Definition
Maintenance Plans
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
STANDBY
Term
during recovery, what option allows you to change the location of one or more data files when the database is restored?
Definition
Move
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
CONTINUE_AFTER_ERROR
Term
what is a Database Snapshot
Definition
a point-in-time read only copy of your database.
No Transaction Logs!
Term
high performance mode
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)
Supporting users have an ad free experience!