Total size in transaction log

  • Hi Everyone,

    Does anyone happen to have a script or know how write one to find out the total size of transaction log the last 24 hours for each databases in the server ?

    Thanks,

    Vu

  • Configure a job to check the log file growth every 24 hours. You can get the desired information from sys.database_files catalog view and configure a mail alert with those details

    [font="Verdana"]- Deepak[/font]

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

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