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

Database-shrink-log-can shrink more than 90%, but after shrinking, the capacity has not decreased. Check the data may be occupied log, temporarily unable to shrink;

2. select log_reuse_wait_desc from sys.databases where name ='HIS_CDC' query results in replication, thinking that cdc was enabled before, but not later, just disabled the job, cdc forgot to disable:

A, first query which libraries have cdc enabled

select * from sys.databases where is_cdc_enabled = 1

b. Query which tables open cdcd

SELECT * FROM sys.tables WHERE is_tracked_by_cdc=1

c. Prohibited table

EXEC sys.sp_cdc_disable_table @source_schema = 'dbo', @source_name = 't1', @capture_instance = 'all';

d. Forbidden library

EXEC sys.sp_cdc_disable_db;

3, the final contraction, if not successful, it is recommended to separate the database, delete the log and then re-attach the database.

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.