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

  • >> Transaction is taking more space after truncating also.

    What is meant by taking more space? Does it mean log file size is same as before?

    Did you shrink the log file?

    Check the log space used using the following command.

    DBCC SQLPERF(LOGSPACE)

    Anyway after truncating log take full database backup.