Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Calculating database and server growth over five year period

Answered Calculating database and server growth over five year period

  • Wednesday, November 07, 2012 5:42 PM
     
     
    Sign In to Vote
    0

    Hi

    Is there an easy way to calculate the database growth over a 5 year period?

    We are warehousing data and I have been asked to provide an expected growth, but not sure if there is an algorithm or bit of SQL that will do it for you?

    If anyone knows it would be great to share.

    Thanks,

     

All Replies

  • Thursday, November 08, 2012 3:54 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    You mean you need the last 5 years history of database growth, if yes then

    -if your backup history still exists and if the backups happening daily without any failure then you can get the information from the backup size from backupset table.

    But 5 years most probably will not be exists I think..& it will be pain to get the report as well, because if any cleanup task exists that will clean up those too..!

    Track-

    http://www.sqlmag.com/article/sql-server-2005/database-growth-tracker

    I just shared My thoughts hope some will have good Idea too..!

    Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.