• Here's an option I had never heard of. I used to do this manually but this is much better :

    There's a way to both take the tail t-log and "shut down" the db at the same time so you're certain to really have everything. Tx gail.!

    http://www.sqlservercentral.com/Forums/FindPost1096908.aspx