Creating a huge tempdb size

If i create tempdb with 50GB allocated and if I read correctly that tempdb
gets rebuilt every time the SQL Server service starts up,does it mean that
the tempdb database gets dropped and recreated everytime at startup and if
so, will it cause some time to start up bcos it has to allocate 50GB. Using
SQL 2000
ThanksTempdb is only cleared at startup so there isn't much difference in startup
time with large tempdb files. The only time there is a startup time penalty
is when the files need to be recreated, such as when tempdb files are moved
with ALTER DATABASE.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23hEDXy61DHA.2000@.TK2MSFTNGP11.phx.gbl...
> If i create tempdb with 50GB allocated and if I read correctly that tempdb
> gets rebuilt every time the SQL Server service starts up,does it mean that
> the tempdb database gets dropped and recreated everytime at startup and if
> so, will it cause some time to start up bcos it has to allocate 50GB.
Using
> SQL 2000
> Thanks
>