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.
1 comment:
Unknown
September 26, 2010 at 10:43 PM
Good one..
Reply
Delete
Replies
Reply
Add comment
Load more...
‹
›
Home
View web version
Good one..
ReplyDelete