MCITP

MCITP

Saturday, September 11, 2010

Move TempDB database to new location

ALTER DATABASE tempdb

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



GO

ALTER DATABASE tempdb

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



GO


Restart the server to take the changes take place.

1 comment: