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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Tempdb Size
- Thread starter GCL2007
- Start date
It depends.
When you start the SQL Server Service, temp db is recreated. The size of this database will be the "Initial Size" of the database. Assuming your initial size is not 143 GB, then it will likely get smaller.
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
When you start the SQL Server Service, temp db is recreated. The size of this database will be the "Initial Size" of the database. Assuming your initial size is not 143 GB, then it will likely get smaller.
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
And 'hidden' in George's response is that you don't need to reboot the server. All you really need to do is stop and start the SQL Server services.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question