Tempdb Size Tempdb Size GCL2007 (IS/IT--Management) (OP) 4 Feb 15 19:54 Very rusty SQL Server Admin here.. My question.. I have a tempdb that has grown to 143000000 KB. Will reboot the server clear this out and reset it? SQL Server 2008R2 RE: Tempdb Size gmmastros (Programmer) 4 Feb 15 21:57 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 RE: Tempdb Size SQLBill (MIS) 5 Feb 15 14:49 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: What should I know before I post?