How to move tempdb mdf,ldf files to other disk

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Hrudhay SSChasing Mays Points: 638 More actions · Answer 1

Use the ALTER DATABASE statement, specifying the logical file name as follows:

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

You should receive the following messages confirming the change:

File 'tempdev' modified in sysaltfiles. Delete old file after restarting SQL Server.

File 'templog' modified in sysaltfiles. Delete old file after restarting SQL Server.

noeld SSC Guru Points: 96590 More actions · Answer 2

Yes but you will need to cycle the service after that.

for more info go here

HTH

* Noel