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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

tempdb

Status
Not open for further replies.
ThomH

ThomH

Vendor
Jun 9, 2003
22
0
0
US
Someone increased the database size of the tempdb to 42 gig. The file is now 42 gig. This is the mdf. How to we reduce, or create a new one!
 
Sort by date Sort by votes
Restart the SQL Server, that would recreate TempDB.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
I tried this, but did not work. The tempdb properties are set to 42,960 under the Space allocation, and I can't change that.
 
Upvote 0 Downvote
Are you a sysadmin?

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]
 
Upvote 0 Downvote

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Tempdb ldf file - how best to clear..
Replies
1
Views
91
gmmastros
gmmastros
GCL2007
  • Locked
  • Question
Tempdb Size
Replies
2
Views
29
SQLBill
SQLBill
niall5098
  • Locked
  • Question
TDE and Tempdb
Replies
0
Views
21
niall5098
niall5098
GCL2007
  • Locked
  • Question
TempDB and database maintenance Plan
Replies
1
Views
50
gmmastros
gmmastros
RRinTetons
  • Locked
  • Question
Lost drive with tempdb, SQL Server won't start
Replies
5
Views
56
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top