Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
Alternatives to responding to a full recover log
|
1. backing up the log
2. free disk space so that the log can automatically grow. 3. moving the log file to a disc drive w/ sufficient space 4. increasing the size of a log file. 5. adding a log file on a different disk. 6. completing or killing a long running transaction |
|
Log files and compressed file systems
|
Log files should never be placed on compressed file systems.
|
|
To discover what is preventing log truncation in a given case use?
|
the log_reuse_wait and log_reuse_wait_desc columns from the columns of the sys.database catalog.
|