October 18, 2006 at 12:54 pm
Hi,
I have asp.net app (1.1, IIS6, SQL2000) and using SQLServer for asp.net session state. We run into problem yesterday, the site give an error saying that it failed to connect to sql server session state. I checked the sql server log and it give me this
5144 :
Autogrow of file 'ASPState_log' in database 'ASPState' cancelled or timed out after 30609 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
Can anyone help me explain what this mean. Thanks in advance.
October 18, 2006 at 1:23 pm
Probabely means that the log file was full and that after 30 seconds, the resize still wasn't finished.
As suggested, try manually setting a bigger size (like the maximum needed size for the next few months). I wouldn't use more than 10-25% for the autogrowth setting, but this is usually unneeded if you set the size correctly in the first place.
October 18, 2006 at 3:16 pm
that make sense. Thanks for the quick reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply