Post reply

transaction log

  • September 11, 2006 at 4:10 pm

    #61333

    Hi,

    how to check the transaction log file size and space used for a particular database through scripts apart from sp_spaceused.

    Thanks. 

  • September 11, 2006 at 5:30 pm

    #659775

    Try DBCC SQLPERF (LOGSPACE)

    Greg

     

    Greg

  • September 12, 2006 at 1:36 am

    #659806

    he greg gave the correct command. However, sp_helpdb <database-name> will also give you the information about the transaction log space (along with data file space).

    Pankaj

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

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

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