specify tempdb location | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

specify tempdb location

Does anybody know if it is possible to specify a location for the tempdb (different to the the datafiles and program files) to reside when performing a new installation of SQL server ?

USE master
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = ‘H:Daten empdb.mdf’)
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = ‘H:Daten emplog.ldf’)
GO The server need to be restarted to take effect. —
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Hi Frank, Thanks for your reply; I know that you can alter the location with ALTER DATABASE, but was curious as to whether a location could be specified when SQL server is installed Simon
By default it will place along with other Database files/logs.I believe, there is no option to specify database file locations during installation . Its upto you to change it later .
As frank said, it needs a server resstart .
I am not aware of such an option, though that doesn’t necessarily mean there is no such option. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
Thanks guys
True you don’t have such option to specify, but what we have done is after the installation of SQL Server we run a script to change the TEMPDB location in order to take care application needs in future. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.