Geek Answers Handbook

SQL Server 2008: log autoload canceled by user or timed?

I met with the following error in the database log, some ideas what is wrong?

The autoloading of the Foo_log file in the Foo database was canceled by the user or timeout after 3328 milliseconds. Use ALTER DATABASE to set a lower FILEGROWTH value for this file or explicitly set a new file size.

thanks in advance George

+4
source share
1 answer

I would suggest that you have a too high percentage of the file tree. Try to reduce it to 10% -15%. Second thoughts, depending on the size of your log file, you should change it to increase the size of the MB, not%.

If your log file is 10 GB, then a 10% increase is enough for SQLServer to work with SQL Server.

Also, make sure that there is a lot of free space on the disk where the log file is located.

To change the AutoGrowth property:

  • Right click on the database.
  • Go to the "Properties" section.
  • Then go to the "Files" section.
  • Click on the statistics column or startup log (click ...)

I would also read this article to help you decide if you need automatic autostart. You even need a transaction log - can you switch your database to simple mode?

+9
source

More articles:


All Articles