Shrink the log to as small a size as possible (truncateonly)


You can use the below command to shrink the database as small as possible.

DBCC SHRINKFILE(transactionloglogicalfilename, TRUNCATEONLY)

NOTE: if you don’t know the logical filename of your transaction log use sp_helpfile to list all of your database files.

Thanks for the comment, will get back to you soon... Jugal Shah