SQL Server 2005

[beechill4]

Hi,

is there a way of telling when a database file was changed in size and set to autoextend?

tried the error logs and nothing there.

Thanks

 

[mrdenny]

Are you using SQL 2000 or SQL 2005?

If you are set for full recovery mode then you can use Lumigent Log Explorer to look in the log backups and see when it was done.

Other than that I don't think it's logged anywhere in SQL 2000.

In SQL 2005 you can look at the disk access report in the default reports that it comes with and it will show you the most recent file extentions.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog