Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

TempDB Error Expand / Collapse
Posted Thursday, February 11, 2010 8:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
My Maintenanceplan has failed stating the error as follows

" 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.
Post #864112
Posted Thursday, February 11, 2010 9:44 AM



Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
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..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page\LearnSQLWithBru

Twitter -- BruMedishetty
Post #864161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse