CompTIA DataSys+ (DS0-001)Database Management and MaintenanceEasy
A database administrator is configuring a new production database server. They need to ensure that the database's transaction log file does not grow unbounded, which could lead to disk space exhaustion and database downtime. What is the most effective maintenance task to prevent this issue?
- AIncreasing the size of the database's data files proactively.
- BDisabling transaction logging for non-critical operations.
- CCompressing the transaction log file periodically.
- DImplementing regular transaction log backups.
Show answer & explanationAnswer & explanation
Correct answer: D. Implementing regular transaction log backups.
Regular transaction log backups are crucial for managing the growth of the transaction log. After a successful log backup, the inactive portion of the log can be truncated, freeing up space for new transactions.
Why the other options are wrong
- A. Increasing data file size does not manage the transaction log's growth.
- B. Disabling logging compromises data recovery and integrity, and is generally not recommended for production.
- C. Compressing the log file might temporarily save space but doesn't address the fundamental growth mechanism or allow truncation.
Transaction Log Management
The process of controlling the size and content of a database's transaction log to ensure data recoverability and prevent disk space issues.
- Essential for point-in-time recovery.
- Unmanaged logs can consume all disk space.
- Backups are key to log truncation.
Memory trick: Log files grow like weeds, prune them with backups.