My TempDB databse is about 10GB. When I try to shrink the datbase via Enterprise manager it says that I can get it down to 5MB. I shrink the file using EM and it appears that I have recovered the space. However, the next morning the tempdb is back to 10gb? Is there any reason why I cannot keep the recovered space?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Shrinking Tempdb
- Thread starter dpu
- Start date
- Status
Similar threads
- Locked
- Question