How to track db growth over a period of time

Hello All
Can anyone tell me how I would go about tracking the database/data table
growth over a period of time
thanks
Have a look at http://vyaskn.tripod.com/track_sql_d...ile_growth.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>
|||"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>
One source of this information is the SQL Server log files (not related to
transaction log files). Each time a backup occurs, the size in blocks (1
block = 8192 bytes) is written to the log file. These files are just text
files which are usually stored somewhere under the SQL Server installation
directory and have names like ERRORLOG.x.
Regards,
Simon