Ralf Eisenreich

SQLBlog.DE | ..things to remember

Archive for February, 2008

February 26th, 2008

SQL Server: How to move tempdb?

138 Comments, SQL Server, by Ralf.

USE [master] GO ALTER DATABASE tempdb MODIFY FILE(NAME=’tempdev’, FILENAME=’E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\tempdb.mdf’) GO ALTER DATABASE tempdb MODIFY FILE(NAME=’templog’, FILENAME=’F:\Microsoft SQL Server\MSSQL.1\MSSQL\Log\templog.ldf’)…