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.
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
You can start with this Link :
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 .