I am getting the below error (SQL Server 2008 cluster) for diverse times for last three days, after giving this error in sql server logs, the db has autogrowed 2 times successfully at last, in 61 and 144 seconds, perspectively, what i am curious about is having these errors all of which has timed out in <60 seconds?
What is the default timeout for autogrow, can i set it? The data file autogrowed successfully in 144 sec, while <60 sec attempts has timed out, isn't that odd?
Autogrow of file 'XXX' in database 'XXX' was cancelled by user or timed out after 25350 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.