Shulou(Shulou.com)06/01 Report--

dbcc loginfo(N'SHDAT9154WXADB')

View log status. Status=2, indicating that this log is active.

SELECT [name] ,[database_id] ,[log_reuse_wait] ,[log_reuse_wait_desc] FROM [sys]. [databases] where name='SHDAT9154WXADB'

The wait type is Replication, but this DB is not replicated.

Undo its published status

exec sp_replicationdboption @dbname = N'SHDAT9154WXADB', @optname = N'publish', @value = N'false'

exec sp_removedbreplication SHDAT9154WXADB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.