• What version of SQL are you running? I know that different versions of SQL run shrinking the transaction log differently. When was the last time you did a transaction log backup? Here is the Microsoft article on shrinking the transaction log:

    http://msdn.microsoft.com/en-us/library/ms178037(v=sql.105).aspx

    --------
    For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
    You can also follow my twitter account to get daily updates: @BLantz2455