To change the tempdb data files location:
1) Determine the logical file names for the tempdb database.
The logical name for each file is contained in the NAME column.
USE tempdb
GO
EXEC sp_helpfile
2)Change the location of each file using ALTER DATABASE.
USE master
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\DBData\tempdb.mdf')
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog,FILENAME = 'E:\DBData\templog.ldf')
GO
3) Stop and restart SQL Server.
1 comment:
This worked for me. A word of advice, though, make sure the directory you are moving your tempdb to has proper security in place for SQL to access it. I had been receiving an "Unhandled Exception" until I added the SQL user to the security.
Post a Comment