tempdb

[Shaunt]

Hi,

the problem I have it's not that complicated, and I need a hint

well I want to move the tempdb database files ( mdf,ldf ) in to another folder and another drive. well I cann't detach and attach again as it is system db while system is working, same as masterand msdb.
now if I stop the service by stoping the SQLserver service then after moving the files physically how I'm going o go and change the file path in the tempdb property.

many thanks

D

[skhanal]

You can use alter database to modify the sql server catalog and the changes will take effect after you restart sql service.

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

This is useful.

http://support.microsoft.com/default...NoWebContent=1

[Shaunt]

thanks