Moving Tempdb
In order to move the tempdb database, open SSMS and run the following query:
use master
go
Alter database tempdb modify file
(name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file
(name = templog, filename = 'E:\Sqldata\templog.ldf')
Go
This command assumes that you are
moving the database files to E:\Sqldata directory
No comments:
Post a Comment