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)
 How to shrink tempdb in SQL 7

Author  Topic 

DanielTang
Starting Member

10 Posts

Posted - 2001-05-17 : 06:36:06
Hi,

My tempdb is about 5 Gb in size. Two weeks ago, when I tried to shrink the tempdb manually, it displayed an error message saying the data in the tempdb is corrupted. Now the error message disappears when I run Shrink Database, but the tempdb does not reduce in size. It constantly stays at minimum 5 Gb in size. I reboot the server as well, but it did not make any difference.

Can anyone advise what I should do? Many thanks in advance.

Daniel

   

- Advertisement -