Used many times but often forgotten...
use master
go
alter database tempdb modify file (name = tempdev, filename = '[new_path]\tempdb.mdf')
go
alter database tempdb modify file (name = templog, filename = '[new_path]\templog.ldf')
SQL Server: move TempDB path
Used many times but often forgotten...
use master
go
alter database tempdb modify file (name = tempdev, filename = '[new_path]\tempdb.mdf')
go
alter database tempdb modify file (name = templog, filename = '[new_path]\templog.ldf')
0 commenti:
Post a Comment