Post reply

How we can get the log an data File sizes Increments with Query

  • November 22, 2011 at 10:05 am

    #248330

    Hi Friends, can you Please Help me to write a script that shows each data and log file for each database in a sql instance. the report should show the data files, their sizes, and their grown increment type (% vs MB increment)

    Thanks,

    Maddy

  • November 22, 2011 at 11:55 am

    #1411736

    madhuu1905 (11/22/2011)

    Hi Friends, can you Please Help me to write a script that shows each data and log file for each database in a sql instance. the report should show the data files, their sizes, and their grown increment type (% vs MB increment)

    sp_helpfile

    go

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • November 22, 2011 at 12:06 pm

    #1411743

    Query sys.master_files

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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