数据库“tempdb”日志已满解决办法
运行查询分析器,执行以下SQL语句:
use tempdb
select * from tempdb.dbo.sysfiles
dump transaction tempdb with no_log
dbcc shrinkfile ('templog',1)
select * from tempdb.dbo.sysfiles
运行查询分析器,执行以下SQL语句:
use tempdb
select * from tempdb.dbo.sysfiles
dump transaction tempdb with no_log
dbcc shrinkfile ('templog',1)
select * from tempdb.dbo.sysfiles