Being DBA
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.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)