hi colin...

no need to restart the server...just restart the service(i.e ms sql server start and stop).then delete the old temp db files.

regards

prem

hi

but we can move the tempdb..

just --check the current location of tempdb using

select * from tempdb.sys.databse_files

--now Change the location

Use Master

Go

Alter database tempdb

Modify file(name=tempdev,file name='give file name path here'

go

Alter database tempdb

Modify...