Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>|||That's right.

>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>
>

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.
Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>
|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>
|||That's right.

>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?
|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>
>