Moving Tempdb
I used MS SQL Server Manager Studio and ran this under Database Engine Query.
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'd:\newfolder\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'd:\newfolder\templog.ldf')
Go
No comments:
Post a Comment