如何对SQL Server中的tempdb“减肥”

核心思想就是转移这个临时库到其他盘

USE master

GO

ALTER DATABASE tempdb modify file (name = tempdev, filename ='NewDrive:\Path\tempdb.mdf')

GO

ALTER DATABASE tempdb modify file (name = templog, filename ='NewDrive:\Path\templog.ldf')

GO

转移后删除C盘下面的

tempdb.mdf和templog.ldf即可