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.
12,851 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Olaf Helper 41,006 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 No 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 No comments

  3. tibor_karaszi@hotmail.com 4,301 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 No comments

  4. Olaf Helper 41,006 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 No comments