Share via

sql server database size trent for the past two years without using msdb

NeophyteSQL 241 Reputation points
2021-02-05T04:34:05.693+00:00

Is there a script to evaluate how much the databases have grown in the past 2 years, like do a trend.

thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,246 Reputation points
    2021-02-05T06:57:18.523+00:00

    Without using the backup history from msdb system database, as you wrote in thread subject?
    Do you have a monitoring software, which records database size?

    If not: No way to get the information.

    0 comments
  2. NeophyteSQL 241 Reputation points
    2021-02-05T07:26:29.203+00:00

    what if the backup history tables have been deleted

    0 comments
  3. tibor_karaszi@hotmail.com 4,306 Reputation points
    2021-02-05T07:53:29.863+00:00

    The information isn't recorded (except for indirectly in backuphistory), quite simply. So either use backuphistory or roll your own (using your own scripts or some monitoring tool).

    If you didn't record this yourself and backup history isn't available, then you are out of luck.

    0 comments
  4. Olaf Helper 43,246 Reputation points
    2021-02-05T07:55:05.763+00:00

    what if the backup history tables have been deleted

    Then you lost the requested information?

    Do you have a most recently backup, before the history was deleted? Then restore it under a different database name then "msdb" as common user database.

    0 comments