How do I view the database size information history?
I want data like
Check Monthly Growth of Database in SQL Server
But the data displayed is backup size. Can I know the history of database size from rows data and logs in the previous months / years? As in [size] in [sys]. [database_files]
Thanks for your answer.
1 Answer
T-SQL Script to Show Database Growth Based on Backup Sizes Change the 'XXXX' to your database name prior to running. With this information, you can give a pretty good idea to your customer about an average data growth, month by month for the past X months.
1
