Question

Sql server 2005 database filesize auto grow

SQL Server 2005, SQL Server performance tuning

Hi i'm running sql server 2005 sp2 on a w2k cluster; i'm expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it.
Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the file size

There is probably a job scheduled to run which is causing the auto grow. Check the SQL Agent and see what jobs are scheduled. You can also fire up SQL Profiler and see what's running on the SQL Server and when the autogrow event occurs.

If the autogrow is happening at night it's probable that the maintenance plan is causing the autogrow. Normal database maintenance requires that the database have enough free space to contain the largest index being worked on twice, so if there is not enough free space the server will grow the database to make enough room.