How to Know Growth of Database in Sql Server
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...
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.
Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.
