To shrink the Trucated Log file.
Following code always shrinks the Trucated Log
File to minimum size possible.
USE Master
--You can replace with the database name but if it doesnt
--works then replace with master databas)..... http://blog.joggee.com/?p=65