server 2 task(s) are sleeping waiting for space to become available in the log segment for database...

最新推荐文章于 2023-01-12 16:38:51 发布

iteye_8877

最新推荐文章于 2023-01-12 16:38:51 发布

阅读量289

点赞数

文章标签：数据库

00:00000:00004:2007/07/19 10:07:45.36 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:07:47.22 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:08:45.95 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:09:46.54 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:10:47.13 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.

解决办法：dump tran cwbase16 with trancate_only