SQL Server Performance Forum – Threads Archive
specify tempdb locationDoes 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 ?
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = ‘Haten empdb.mdf’)
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = ‘Haten emplog.ldf’)
GO The server need to be restarted to take effect. —
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 />
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.