Unrestricted file growth Log Error

Question

Hi All,

I know there are a few threads on this but I can't seem to find a resolution to this.

Have a small SQL Web application running on SQL Express 2005

mdf - 41mb by 1MB, unrestricited growth
ldf - 141mb by 20MB, restricted growth to 2097152 MB

Auto growth is enabled
Unable to set unrestricted growth on Log file as 2097152MB is the max anyway

We have received the below error in the past few days 

Two days ago
Autogrow of file 'log1' in database 'database' was cancelled by user or timed out after 203 milliseconds.  
Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

Today
Autogrow of file 'log1' in database 'database' was cancelled by user or timed out after 2547 milliseconds.  
Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

only difference is milliseconds

Any ideas would be much appreciated

Thanks,

Paullyie

Answer 1

Hi.

You Can set auto growth from management studio .

Go to databases---->properties----->Files

Answer 2

You should set the database into the SIMPLE recovery model, that way the transaction log is managed automatically and not likely to error out because of growth problems.

The tacit assumption is that the transaction log is not used, the disaster recovery method is based on full database backups.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012