TempDb Shrink Errors - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

TempDb Shrink Errors

Author

Topic

monty
Posting Yak Master

130 Posts

Posted - 2006-10-15 : 09:25:49

Earlier some time back i did post a query regarding shrinking tempdb, we hav done that and cld reclaim the needed space..
But when we ran DBCC CHECKDB command we found the following error:
Server: Msg 8999, Level 16, State 1, Line 1

Database tempdb allocation errors prevent further CHECKDB processing.

Server: Msg 8906, Level 16, State 1, Line 1

Page (1:87) in database ID 2 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.

Server: Msg 8905, Level 16, State 1, Line 1

Extent (1:136) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

DBCC results for 'tempdb'.

CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.

CHECKDB found 2 allocation errors and 0 consistency errors in database 'tempdb'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tempdb ).

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

when i reffered the microsoft site i found that its related to some H/W probs.. Everything looks fine But are the errors going to cause any prob in future.. Please ur suggestions are welcomed

its me monty

Kristen
Test

22859 Posts

Posted - 2006-10-15 : 14:06:00

How did you shrink TEMPDB?

In the previous thread I recommended you did not Shrink it as it may cause corruption

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73199

The link that khtan posted there:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64914

has a link to an MS article on the very specific steps you need to follow if you are going to Shrink TEMPDB - i.e.:

http://support.microsoft.com/default.aspx/kb/307487

But either way, if you restart SQL Server you should get a Clean TEMPDB and it should be reinitialized to the default start-up size (but if not delete the file whilst SQL Service is stopped, as per description in the other thread), so if this is not happening the likelihood is that you have a more serious problem.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources