You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
A server named ABC-SQL1 has a tape backup device named Tape1 attached to it.
An application named SalesApp is used by the Sales department. SalesApp stores data in a
database named SalesAppDB on ABC-SQL1.
Sales users report that SalesApp is displaying an error. You discover that the log file for
SalesAppDB is full.
You want to clear log file space and ensure the LSN (log sequence number) chain is not affected
by backing up the log file.
Which of the following backup statements should you use?
A.
BACKUP LOG SalesAppDB TO Tape1
B.
BACKUP LOG SalesAppDB TO Tape1 WITH TRUNCATE_ONLY
C.
BACKUP LOG SalesAppDB TO Tape1 WITH NO_TRUNCATE
D.
BACKUP LOG SalesAppDB TO Tape1 WITH NORECOVERY
E.
BACKUP LOG SalesAppDB TO Tape1 WITH COPY_ONLY
Explanation: