[SQL Server] Déplacement de TempDB

  • Imprimer

select name,physical_name

from sys.master_files

where database_id=DB_ID('tempdb')

 

alter database tempdb

modify file (name=tempdev, filename='T:\tempdb.mdf')

go

alter database tempdb

modify file (name=templog, filename='T:\templog.ldf')

go

alter database tempdb

modify file (name=tempdev2, filename='T:\tempdev2.ndf')

 

go