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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-02 : 13:09:39
|
| Sam writes "I have normally had no problem shrinking tempdb through the console, but suddenly, I get error 8909 Table Corrupt: Object ID 0, index ID 0, page ID (1:62092). The PageId in the page header = (0:0). I have tried DBCC SHRINKDATABASE AND DBCC SHRINKFILE with the same results, and xp_sqlmaint does not seem to do anything. I have no problem shrinking any other databases, so I am now completely lost. tempdb keeps growing every time I carry out any transactions, and soon it will have used all available mb of filespace. This is SQL Server Version 7.00.623" |
|
|
|
|
|
Problem shrinking tempdb