February 11, 2010 at 8:40 am
Team,
My Maintenanceplan has failed stating the error as follows
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Could not allocate space for object 'dbo.SORT temporary run storage: 140737729003520' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have even restarted the services of sqlserver but of new use.
February 11, 2010 at 9:44 am
Have you read the error statement completely and what have you done in response to it ?
Your temp DB file settings need to re-looked either add additional file or change the autogrowth and Max size settings or check your drive for free space..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply