Moving the tempdb files
December 2nd, 2009
No comments
I always forget the syntax. By putting it on my own blog, I should now be able to look it up quickly!
use master
go
alter database tempdb modify file (name = tempdev, filename = ‘H:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\tempdb.mdf’)
go
alter database tempdb modify file (name = templog, filename = ‘H:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\templog.ldf’)
go