1 确定tempdb数据库的逻辑文件名称以及在磁盘上的当前位置
SELECT name, physical_name FROM sys.master_files WHERE database_id = DB_ID('tempdb');
2 修改位置
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'D:\tempdb.mdf');
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'D:\templog.ldf');
3 停止并重新启动SQL Server服务