Home Forums SQL Server 2005 Administering Transaction is taking more space after shrinking also RE: Transaction is taking more space after shrinking also

  • >>after some hours log file size increases about more than 2gb. Thats the issue.

    May be, there are so many transactions. Check it with Profiler.

    Don't shrink the log file, unless you have shortage of free space.

    What is the data and log file size?