DRAG DROP
You have a SQL Server 2012 database named Database1. Database1 has a data file
named Database1_data.mdf and a transaction log named Database1jog.ldf.
Database1_data.mdf is 1.5 GB. Database1jog.ldf is 1.5 terabytes.
A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can perform
transaction log backups in the future.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.
-set recovery model to SIMPLE
-DBCC shrinkfile(database1_log,1)
-set recover model to FULL
Assuming it is an emergency this would be the best option. I think ‘with truncate only’ is obsolete in 2012.
see for more:
https://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/
agree with your ANS
-set recovery model to SIMPLE
-DBCC shrinkfile(database1_log,1)
-set recovery model to FULL
MS no longer recommand using truncate only