Post reply

T-SQL script for Transaction log file sizing?

  • March 10, 2006 at 4:12 am

    #365467

    Hi,

    We have 26+ Standalone SQL 7/2000 Servers which we are looking to migrate to a EMC SAN cluster solution.  I am currently going through a sizing exercise to see how many disks we will require for this purpose.  I have quickly determined the total database size for each server but would like to find out how much space the transaction log files are currently occupying. 

    Does anyone know of a quick way of doing this?  Is there t-sql script I can run which will report this information?

    Regards,

    Mark

  • March 10, 2006 at 4:55 am

    #625898

    If you give sp_helpfile the logical name of the log, it will report among other things, the physical filesize.

    /Kenneth

  • March 10, 2006 at 5:06 am

    #625903

    Of course... how simple!

    Thanks Kenneth.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply