Version - SQL Server 2008 standard edition with SP1.
Database File setting as follows
MDF file growth 1 MB unrestricted growth
LDF file growth restricted file growth up to 2TB (by default SQL values)
Even though I am facing problem some of the transaction not completed and information available at error log file
10/16/2013 14:34:57,spid63,Unknown,Autogrow of file 'databasename_log' in database ''databasename' was cancelled by user or timed out after 47 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
Pl. suggestion me what could be issues, why that tracsaction accouping upto 2TB?
After that I have changed data & log file setting
MDF file growth 100 MB unrestricted growth
LDF file growth restricted file growth up to 30GB