Home Forums Article Discussions Article Discussions by Author Discuss content posted by VM Shrinking the transaction log RE: Shrinking the transaction log

  • December 10, 2009 at 9:27 am

    #1090662

    Lynn Pettis (12/10/2009)

    I'm confused, what is the question asking? I'd like to answer it today, but with this question it would all be a shot in the dark.

    ( It would all be a shot in the dark ). That's what I did. Checked all and got points. I am not sure about this option. Will have to test it on some server. I thought its same and never observed time in seconds.

    -- If a log file has lots of free space, shrinking the transaction log file in SQL Server 2005 is faster than shrinking the transaction log file in SQL Server 2000.

    SQL DBA.