Wednesday, June 20, 2012

Moving tempdb on SQL 2008 R2

Moving tempdb to a new location:

1) Connect to the SQL server and run this query:
USE master
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = '[new path]\tempdb.mdf');GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = '[new path]\templog.ldf');GO


2) Stop the SQL service
3) Move tempdb.mdf and templog.ldf to the new location
4) Start the SQL Service

No comments:

Post a Comment