Tempdb 파일이동

ALTER DATABASE tempdb

MODIFY FILE

(NAME = tempdev,

FILENAME = 'D:\DB_FILE\tempdb.mdf');

GO

ALTER DATABASE tempdb

MODIFY FILE

(NAME = templog,

FILENAME = 'D:\DB_FILE\templog.ldf');

GO

use master

   

sp_helpfile tempdev

sp_helpfile templog

sp_helpdb tempdb