Multiple Tempdb

Hi,
Is it possible to have multiple tempdb on 1 sql server. If
yes please pass on the info.
Thanks in advance.
No. But you can relocate TempDB or span it across multiple files on multiple
devices if necessary. This may help with performance or storage management
issues if that is your goal.
Use ALTER DATABASE to add / modify files in TempDB, then restart the server.
David Portas
SQL Server MVP
|||You could install another instance of SQL Server. You would lose though in
available memory as it is likely you would set a maximum for each instance
which would be less than the single instance would have access to.
"Moh" <anonymous@.discussions.microsoft.com> wrote in message
news:408401c4a009$e215b600$a301280a@.phx.gbl...
> Hi,
> Is it possible to have multiple tempdb on 1 sql server. If
> yes please pass on the info.
> Thanks in advance.