Being DBA
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
‹
›
Home
View web version
No comments:
Post a Comment