Term
|
Definition
Hardware failure:
User error:
Application failure:
Software failure:
Too much privilege:
Physical disaster: |
|
|
Term
|
Definition
| it takes the whole server down, |
|
|
Term
| masterdb only needs to be backed up when |
|
Definition
you create a DB, change
configuration values, configure SQL logins, or similar changes
to DBs on a server |
|
|
Term
| what should be backed up more often development db or production db |
|
Definition
|
|
Term
| A _______ does not need frequent regular backups |
|
Definition
|
|
Term
| A db that is updated 7x24 should be backed up ______ |
|
Definition
|
|
Term
| A db used that is updated nightly by batch runs should be backed up at _________ |
|
Definition
|
|
Term
| When to schedule backups? |
|
Definition
| Do them when the db usage is as low as possible, for best speed of backup (off-peak hours), but this is not always possible |
|
|
Term
| Do you need to store backups off site? |
|
Definition
|
|
Term
|
Definition
Simple
Full
Bulk-Logged |
|
|
Term
|
Definition
SQL Server minimally logs transactions that occur, then
truncates the transaction log at each checkpoint |
|
|
Term
| what does the simple recovery model not allow |
|
Definition
| transaction log backups or recovery to a point in time or point of failure |
|
|
Term
| msdb, master, and tempdb databases use the_____ recovery model by default |
|
Definition
|
|
Term
| model db uses the ____ recovery model by default |
|
Definition
|
|
Term
|
Definition
Provides complete transaction logging; all transactions are
logged into the transaction log, which is never truncated during normal operations |
|
|
Term
| Bulk-logged recovery model: |
|
Definition
Provides a mechanism for minimally logging information to the
transaction log during bulk operations such as BULK INSERT,
SELECT INTO statements, and BCP inserts |
|
|
Term
|
Definition
| Captures all pages within a DB that contain data; pages without data are not included in the backup |
|
|
Term
|
Definition
| A means to back up only those parts of the DB that are changing |
|
|
Term
| A partial backup normally includes the primary filegroup and read-write filegroups |
|
Definition
| May or may not include read-only filegroups |
|
|
Term
|
Definition
Is a copy of files or filegroups of a database
Typically used for very large databases for which full backup is
infeasible
A transaction log backup is also needed with this type of backup
if read/write files or filegroups are included |
|
|
Term
|
Definition
| Captures all extents that have changed since the last full backup |
|
|
Term
| Differential backups can only be used in conjunction with ________ |
|
Definition
|
|
Term
|
Definition
forces the restore over top of an existing
db |
|
|
Term
|
Definition
must be specified if you want the db to be
online and accessible for transactions after RESTORE operation
Includes the redo & undo phases
Additional backups cannot be restored
Is the default |
|
|
Term
|
Definition
if used, db is left in a RECOVERING
state
Omits the undo phase to preserve uncommitted transactions
Allows you to apply differential and/or transaction log backups |
|
|
Term
|
Definition
allows you to issue SELECT statements
while still applying additional differential and/or transaction log
restores |
|
|
Term
|
Definition
allows you to change the location of db files
during the restore operation |
|
|
Term
|
Definition
Indicates that the contents of the page are not consistent
Occurs when the page checksum does not match the contents
of the page
Usually occurs when a disk controller begins to fail |
|
|
Term
| If page corruption occurs in an index, |
|
Definition
| drop and recreate the index to remove the corruption |
|
|
Term
| If page corruption occurs in a table or on the primary key, |
|
Definition
| you must perform a restore to fix it |
|
|
Term
| To restore from damaged backup media |
|
Definition
use the
CONTINUE_AFTER_ERROR option for a RESTORE
DATABASE or RESTORE LOG command |
|
|
Term
|
Definition
| a two phase process that occurs when SQL Server is started, REDO then UNDO phase |
|
|
Term
Snapshot can be used to revert the source db to the snapshot
state in the event of a user error |
|
Definition
| (such as dropping a table) |
|
|
Term
| Only ______ Database Snapshot can exist for the source db |
|
Definition
|
|
