Question :
My requirement is to get the database size information collected daily, I did not find any option to get database growth over a period of time.
Someone please advise what the correct method for this could be.
Answer :
Refer the link which details as creating a table, stored procedure and a SQL Agent job to execute that sp and save details in that table everyday
http://sqljourney.wordpress.com/2013/02/13/sql-server-track-database-size-growth-trend/
-
You can start with this Link :
https://stackoverflow.com/questions/176379/determine-sql-server-database-size -
From this link you will get the CURRENT databases sizes.
-
For getting the DB’s sizes per Date or Datetime, you should schedule (create a job) that run the query and insert his results into a table (new table which you should to create for this ).
-
After all these steps you will get a table that holds per date the databases sizes .