SQL Server 2008 R2 TempDb taşıma ( move)

TempDB nin nerede olduğunu sorgulayan T-SQL code

SELECT name, physical_name AS CurrentLocation

FROM sys.master_files

WHERE database_id = DB_ID(N'tempdb');

GO

-TempDB nin yerini değiştiren T-SQL code

USE master;

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'D:\SQL\tempdb.mdf');

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = templog, FILENAME = 'D:\SQL\templog.ldf');

GO