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.
1 comment:
Unknown
September 26, 2010 at 10:43 PM
Good one..
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Good one..
ReplyDelete