Being DBA
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.
‹
›
Home
View web version