<div>
msdb has history for 6 years.. so maybe a rpt like this for every first of month:<br />
<br />
Jan 1 2012: ___GB<br />
Feb 1 2012: ___GB<br />
Mar 1 2012: ___GB<br />
Apr 1 2012: ___GB<br />
etc<br />
<br />
the GB___ can be approx.<br />
<br />
is this the only way to gauge the historical db size (without having profiled it periodically, which would been ideal)
</div>


msdb has history for 6 years.. so maybe a rpt like this for every first of month:

Jan 1 2012: ___GB
Feb 1 2012: ___GB
Mar 1 2012: ___GB
Apr 1 2012: ___GB
etc

the GB___ can be approx.

is this the only way to gauge the historical db size (without having profiled it periodically, which would been ideal)

<div>
thanks.. now that is the compressed backup size, right? is there a way to deduce the actual db &nbsp;size?
</div>


thanks.. now that is the compressed backup size, right? is there a way to deduce the actual db  size?

<div>
could you please check <br />
<a href="https://www.experts-exchange.com/questions/28689890/how-to-get-first-available-date-in-a-month-TSql-query.html" rel="ugc">https://www.experts-exchange.com/questions/28689890/how-to-get-first-available-date-in-a-month-TSql-query.html</a><br />
related to this, pl.
</div>


could you please check
https://www.experts-exchange.com/questions/28689890/how-to-get-first-available-date-in-a-month-TSql-query.html [https://www.experts-exchange.com/questions/28689890/how-to-get-first-available-date-in-a-month-TSql-query.html]
related to this, pl.

<div>
<div class="content wysiwyg-content">
how can you spin a query from msdb that can give approx. size of DB how it was historically.
</div>
</div>


how can you spin a query from msdb that can give approx. size of DB how it was historically.

make a history of database size (aprox) using backup history..

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.