We started getting the following error today on a server I just rolled out on Sunday. Autogrow of file 'CMN_PRD_Data' in database 'CMN_PRD' cancelled or timed out after 15594 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. It is set to autogrow 200MB at a time unrestricted. This does not seem like a very large amount to me. There is plenty of room on the disk. Any ideas why this would time out? These databases had been autogrowing on the old server without issue. Have I missed some configuration setting or something?
Hi, Referhttp://support.microsoft.com/kb/822641 Regards Hemantgiri S. Goswami MS SQL Server MVP ------------------------- "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
Check if there are any hardware issues on the server to accomodate the SQL process execution, also check Hemant's link. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
