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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shrink tempdb..?

Status
Not open for further replies.
kenjoswe

kenjoswe

Technical User
Sep 19, 2000
327
SE
Hi all,

How can I shrink then tempdb database?
I have tried "Shrink database" but that doesn't seems to affect the size.

I have 8979 allocated and 8974 free in the database.

Can I just delete the tempdb database and recreate it?

/Kent J.
 
Sort by date Sort by votes
RobertT687,

I have tried to stop and start the server.
But it didn't help. Same size on tempdb.

/Kent J.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Tempdb ldf file - how best to clear..
Replies
1
Views
247
gmmastros
gmmastros
GCL2007
  • Locked
  • Question
Tempdb Size
Replies
2
Views
96
SQLBill
SQLBill
niall5098
  • Locked
  • Question
TDE and Tempdb
Replies
0
Views
68
niall5098
niall5098
GCL2007
  • Locked
  • Question
TempDB and database maintenance Plan
Replies
1
Views
95
gmmastros
gmmastros
1DMF
  • Locked
  • Question
Transaction Log File - exceptionally large , can't shrink? 3
Replies
13
Views
236
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top