Thursday, March 10, 2011

Shrink tempdb database

Shrink tempdb database


dbcc shrinkfile(tempdev,70240)

dbcc shrinkdatabase('tempdb')

dbcc opentran(tempdb)


If above query doesn’t work run below command one by one and shrink tempdb again

-----
DBCC FREEPROCCACHE

DBCC FREESYSTEMCACHE('ALL')
------

No comments:

Post a Comment