改变TempDB的位置
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'D:\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'D:\templog.ldf')
go
go
Alter database tempdb modify file (name = tempdev, filename = 'D:\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'D:\templog.ldf')
go