我一直用
DBCC SHRINKDATABASE (vod)
BACKUP LOG vod WITH TRUNCATE_ONLY
语句清除日志
但是我又一旦时间没有清日志,日至文件长得很大3090MB我现在再用这段语句就没有办法清除日志了。并且报错如下
Server: Msg 1205, Level 13, State 57, Line 1
Transaction (Process ID 51) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
我现在该怎么做呢?
---------------------------------------------------------------
DUMP TRANSACTION @DataBaseName WITH NO_LOG
DBCC SHRINKFILE( @LogoFileName,@NewSize) --收缩 日志
这样试试