Shrink the log to as small a size as possible (truncateonly) Leave a reply 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. Share this: Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on LinkedIn (Opens in new window) LinkedIn Share on Reddit (Opens in new window) Reddit Print (Opens in new window) Print Share on X (Opens in new window) X Email a link to a friend (Opens in new window) Email Share on Pinterest (Opens in new window) Pinterest Like Loading... Related