DP-300 · Question #425
You have an Azure subscription that contains a Microsoft SQL Server 2022 on Windows Server 2022 virtual machine named Server1. Server1 contains a database named DB1. You need to back up DB1. The…
The correct answer is A. BACKUP LOG db1 TO URL. A Microsoft SQL Server database log backup copies the transaction log, which records all changes made to the database since the last log backup. This allows you to recover the database to a specific point in time after a full database backup. It's like an incremental backup for…
Question
Options
- ABACKUP LOG db1 TO URL
- BBACKUP DATABASE db1 WITH FILE_SNAPSHOT TO URL
- CBACKUP DATABASE db1 TO URL
- DBACKUP DATABASE db1 TO DISK
How the community answered
(19 responses)- A74% (14)
- B16% (3)
- C5% (1)
- D5% (1)
Explanation
A Microsoft SQL Server database log backup copies the transaction log, which records all changes made to the database since the last log backup. This allows you to recover the database to a specific point in time after a full database backup. It's like an incremental backup for SQL Server, preserving only the new changes. https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/transaction-log- backups-sql-server https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sq
Topics
Community Discussion
No community discussion yet for this question.