70-465 Question #114: Real Exam Question with Answer & Explanation

Question

You have a SQL Server 2012 database named DB1. You have a backup device named Device1. You discover that the log file for the database is full. You need to ensure that DB1 can complete transactions. The solution must not affect the chain of log sequence numbers (LSNs). Which code segment should you execute?

Options

• ABACKUP LCG DB1 TO Device1 WITH COPY_ONLY
• BBACKUP LOG DB1 TO Device1
• CBACKUP LOG DB1 TO Device1 WITH NCRECCVERY
• DBACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY

Explanation

To resolve a full transaction log and allow new transactions without breaking the log sequence number (LSN) chain, a standard transaction log backup is required.

Common mistakes.

• A. The LCG keyword is not a valid backup type in SQL Server; the correct keyword for backing up the transaction log is LOG.
• C. The NCRECCVERY option is not a valid parameter for the BACKUP LOG command in SQL Server.
• D. The TRUNCATE_ONLY option for BACKUP LOG was deprecated in SQL Server 2008 and removed in SQL Server 2012, making this command invalid for the specified version, and it would break the log chain.

Concept tested. SQL Server transaction log backup and management

Reference. https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql

No community discussion yet for this question.