Being DBA
MCITP
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment