Wednesday, March 7, 2012

reducing tempdb

I am trying to reduce the size of my tempdb using the DBCC SHRINKFILE command and get the following error.

DBCC SHRINKFILE: Page 1:1164376 could not be moved because it is a work table page.

How can I get around this so I can shrink the db?

Hi

Please check the following KBA.

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

Jag

No comments:

Post a Comment