Exam 70-764 topic 1 question 245 discussion

Actual exam question from Microsoft's 70-764

Question #: 245
Topic #: 1

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?

A. BACKUP LCG DB1 TO Device1 WITH COPY_ONLY
B. BACKUP LOG DB1 TO Device1
C. BACKUP LOG DB1 TO Device1 WITH NCRECCVERY
D. BACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY

Show Suggested Answer

Suggested Answer: B 🗳️
References:
http://msdn.microsoft.com/en-us/library/ms186865.aspx
http://msdn.microsoft.com/en-us/library/ms179478.aspx
http://msdn.microsoft.com/en-us/library/ms190925.aspx

by Guest at Nov. 26, 2019, 3:48 p.m.

Comments

Submit Cancel

Guest

Highly Voted 5 years, 6 months ago

Tricky question To not affect the LSN you would need to do a with copy_only, however that would not free up space in the log so it would not allow to complete transactions So than a normal log backups seems to be the only logical option

upvoted 5 times

Anette

4 years, 7 months ago

so, you mean A or B?

upvoted 1 times

...

Cococo

Most Recent 4 years, 7 months ago

So they're describing the current setup and it has Device1 as a Backup Storage and you need manually backup the log into this device and it is going to take the next LSN.. Seems like B

upvoted 1 times

...