在新UAT服務器上，需要將tempdb放置在SSD（固態(tài)硬盤）上。由于SSD（固態(tài)硬盤）特性，所以tempdb的文件只能放置在D盤下面，而不能是D盤下的某一個目錄下面。

ALTER DATABASE tempdb

MODIFYFILE(name='tempdev', filename='D:/tempdb.mdf') ;

GO

ALTER DATABASE tempdb

MODIFYFILE(name='templog', filename='D:/templog.ldf') ;

GO

修改了tempdb的目錄后，重啟數據庫服務，結果出現錯誤信息：“FCB::Open failed: Could not open file D:/tempdb.mdf for file number 1. OS error: 2(The system cannot find the file specified.)" ，具體錯誤信息如下所示：

2015-05-27 ;11:56:44.88 spid9s The resource database build version is 12.00.2000. This is an informational message only. No user action is required.

2015-05-27 ;11:56:45.49 spid9s Starting up database 'model'.

2015-05-27 ;11:56:45.67 Server The SQL Server Network Interface library successfully registered the Service PRincipal Name (SPN) [ MSSQLSvc/GEK-MIS01UAT.gfg1.esquel.com ] for the SQL Server service.

2015-05-27 ;11:56:45.67 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/GEK-MIS01UAT.gfg1.esquel.com:1433 ] for the SQL Server service.

2015-05-27 ;11:56:45.83 spid9s Clearing tempdb database.

2015-05-27 ;11:56:45.84 spid9s Error: 5123, Severity: 16, State: 1.

2015-05-27 ;11:56:45.84 spid9s CREATE FILE encountered operating system error 5(access is denied.) while attempting to open or create the physical file 'D:/tempdb.mdf'.

2015-05-27 ;11:56:45.94 spid9s Error: 17204, Severity: 16, State: 1.