Mover Tempdb

Extraido de

INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...us;Q224071

eso si, esta en ingles:
Moving Tempdb
You can move tempdb files by using the ALTER DATABASE statement.
1.. Determine the logical file names for the tempdb database by using
sp_helpfile as follows:
use tempdb
go
sp_helpfile
go
The logical name for each file is contained in the name column. This
example uses the default file names of tempdev and templog.


2.. 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.

3.. Using sp_helpfile in tempdb will not confirm these changes until you
restart SQL Server.
4.. Stop and restart SQL Server.

Saludos

Adrian D. Garcia
NDSoft
MCSD

"Juan Carlos Marcano" escribió en el mensaje
news:6dfb01c40202$16f1c4f0$

Quiero mover de disco la base de datos temporal (tempdb),
no es posible instalar nuevamente SQL ya que es un
ambiente de produccion, y no se desea una solucion
agregandole otro filegroup en otro disco.