데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

tempdb위치를 옮기는방법

작성자

김이영(chrom)

작성일

2005-08-17 17:00

조회수

2,107

MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).

modify 절을 이용하면 새로운 disk 로 데이터 화일을 이동할수 있습니다.

bol 에 잘 나와 있습니다. 확인후 적용해 보세요.. ^^;;

sqler님이 2005-08-17 17:30에 작성한 댓글입니다. Edit Ｘ

You can move tempdb files by using the ALTER DATABASE statement.

1.	Determine the logical file names for the tempdb database by using sp_helpfile as follows:`use tempdb go sp_helpfile go`The logical name for each file is contained in the name column. This example uses the default file names of tempdev and templog.
2.	Use the ALTER DATABASE statement, specifying the logical file name as follows:`use master go Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf') go Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf') go`You should receive the following messages confirming the change: File 'tempdev' modified in sysaltfiles. Delete old file after restarting SQL Server. File 'templog' modified in sysaltfiles. Delete old file after restarting SQL Server.
3.	Using sp_helpfile in tempdb will not confirm these changes until you restart SQL Server.
4.	Stop and restart SQL Server.