(这个方法没有用过,若数据服务在正常模式下不能删除,则在单用户模式下试试)
sp_dropsegment system,'tempdb','master'
go
sp_dropsegment 'default','tempdb','master'
go
sp_dropsegment logsegment,'tempdb','master'
go
查看主设备上是否还有tempdb分配,若segmap为1则在主设备上有分配
select dbid,name,segmap from sysusages,sysdevices
where sysdevices.low<=sysusages.size+vstart
and sysdevices.high>=sysusages.size+vstart-1
and dbid=2 and (status =2 or status=3)