Podcast
Questions and Answers
What is the purpose of the transaction log?
What is the purpose of the transaction log?
- To perform manual backups as needed
- To schedule regular database backups
- To store full database backups
- To capture all changes made to the database since the last backup (correct)
Which type of backup is performed using the BACKUP DATABASE command in SQL Server?
Which type of backup is performed using the BACKUP DATABASE command in SQL Server?
- Full database backup (correct)
- Differential backup
- Incremental backup
- Transaction log backup
Why are transaction log backups essential for point-in-time recovery?
Why are transaction log backups essential for point-in-time recovery?
- To overwrite existing backup files
- To reduce storage space
- To schedule regular backups
- To capture all changes for precise recovery (correct)
Where can transaction log backups be stored to protect against hardware failures?
Where can transaction log backups be stored to protect against hardware failures?
What does the WITH INIT parameter do in a database backup command?
What does the WITH INIT parameter do in a database backup command?