De-Replication issue on 2012

• andy 18189

  Grasshopper

  Points: 13

  More actions

  April 4, 2015 at 11:47 pm

  #316131

  I have come across what appears to be quite a difficult database problem.

  I have a database which I believe was copied to a server without replication setup from a server were replication was setup. The log file is continually growing, this is now over 150GB.

  sys.databases log_reuse_wait_desc tells me it's due to replication.

  Server details

  OS Microsoft Windows NT 6.1 (7601)

  SQL Server Version 11.0.2100.60

  Latin1_General_CI_AS, SQL Server 2012 - Compatibily Level 110

  I have tried running :-

  exec sp_replicationdboption 'myDB','publish','false'

  exec sp_replicationdboption 'myDB','merge publish','false'

  exec sp_removedbreplication 'myDB'

  I have also tried setting up repliciation on this server and done all three replication methods one at a time and the deleting them.

  I have also tried a full backup and restore.

  I am now running a checked but am completely out of ideas. Please have you any ideas.

  Regards

• andy 18189

  Grasshopper

  Points: 13

  More actions

  April 5, 2015 at 3:36 am

  #1788789

  I have found a reference to having CDC enable can cause this.

  I found it and fixed with……

  SELECT name,recovery_model_desc,log_reuse_wait_desc,is_cdc_enabled FROM SYS.DATABASES

  EXECUTE sys.sp_cdc_disable_db;

  I have been able to reduce the logs now, I re-enabled it afterwards.