Post reply

Database File Growth Report Script

  • September 4, 2025 at 11:49 am

    #4646207

    Comments posted to this topic are about the item Database File Growth Report Script

  • September 5, 2025 at 12:10 pm

    #4646551

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • September 12, 2025 at 1:02 pm

    #4650593

    Thanks again for this useful post, however, when SP runs for 1st time, [DataUpdatedOn] is always null. I went through the 2 SPs but not sure I understand when this gets populated. Thanks for your help

  • September 19, 2025 at 6:51 am

    #4654450

    Thanks for pointing this out. I missed to add the default datetime constraint for DataUpdateON column of the table. Please use below updated script to create the table-

    CREATE TABLE [DBUtility].[dbo].[tbl_DatabaseFileSpace](

    [InstanceName] [nvarchar](50) NULL,

    [DatabaseName] [nvarchar](50) NULL,

    [FileName] [nvarchar](50) NULL,

    [FileType] [nvarchar](20) NULL,

    [TotalSizeMB] [decimal](10, 2) NULL,

    [FreeSpaceMB] [decimal](10, 2) NULL,

    [PercentFreeSpace] [decimal](10, 2) NULL,

    [AutoGrowthMB] [decimal](10, 2) NULL,

    [MaxSizeMB] [nvarchar](50) NULL,

    [DataUpdatedOn] [datetime] DEFAULT GETDATE() NULL

    ) ON [PRIMARY]

    GO

     

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

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