Database File Growth History

-- SCRIPT 1

SELECT te.name, t.DatabaseName, t.FileName, t.StartTime, t.ApplicatioNname

FROM fn_trace_gettable('M:\MSSQL10.MSSQLSERVER\MSSQL\Log\log.trc', NULL) AS t

INNER JOIN sys.trace_events AS te ON t.EventClass = te.trace_event_id

WHERE te.name LIKE '%Auto Grow'

ORDER BY StartTime desc

-- SCRIPT 2

DECLARE @path NVARCHAR(1000)

SELECT @path = Substring(PATH, 1, Len(PATH) - Charindex('\', Reverse(PATH))) +

                      '\log.trc'

FROM   sys.traces

WHERE  id = 1

PRINT @path

SELECT databasename,

       e.name   AS eventname,

       cat.name AS [CategoryName],

       starttime,

       e.category_id,

       loginname,

       loginsid,

       spid,

       hostname,

       applicationname,

       servername,

       textdata,

       objectname,

       eventclass,

       eventsubclass

FROM   ::fn_trace_gettable(@path, 0)

INNER JOIN sys.trace_events e ON eventclass = trace_event_id

INNER JOIN sys.trace_categories AS cat ON e.category_id = cat.category_id

WHERE  e.name IN( 'Data File Auto Grow', 'Log File Auto Grow' )

ORDER  BY starttime DESC