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
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = ‘H

aten empdb.mdf’)
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = ‘H

aten emplog.ldf’)
GO The server need to be restarted to take effect. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
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=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>