To shrink the DB Transaction Log file,USE DatabaseNameGODBCC SHRINKFILE(<log file name>, 1) To find out the Log file details:USE DATABASENAMEexec sp_helpfile Bookmark on DeliciousDigg this post Recommend on FacebookShare with StumblersTweet about itSubscribe to the comments on this post Read More

Tags: ,