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?
Flashcards
Purpose of transaction log?
Purpose of transaction log?
Captures all changes made to the database since the last backup.
BACKUP DATABASE command type?
BACKUP DATABASE command type?
Full database backup
Why are transaction log backups essential for point-in-time recovery?
Why are transaction log backups essential for point-in-time recovery?
To capture all changes for precise recovery.
Where should transaction log backups be stored?
Where should transaction log backups be stored?
Signup and view all the flashcards
What does WITH INIT do?
What does WITH INIT do?
Signup and view all the flashcards
