Wednesday, November 07, 2012 5:42 PM
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.
Thursday, November 08, 2012 3:54 AM
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..!
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.