Hi Krisha,
in order to shrink the logfile you recommend the command:
"DBCC SHRINKFILE (transactionloglogicalfilename, TRUNCATEONLY)"
But BOL for DBCC SHRINKFILE states that:
"TRUNCATEONLY is applicable only to data files."
Would you please comment on...