Home Forums SQL Server 2008 SQL Server Newbies Removing a secondary tempdb file RE: Removing a secondary tempdb file
PearlJammer1
SSCrazy Eights
Points: 8477
More actions
February 28, 2013 at 5:20 am
#1591939
thank you
is this correct then :
DBCC SHRINKFILE ('tempdev2' , emptyfile)
then run the
ALTER DATABASE tempdb REMOVE FILE tempdev2