I can not disable merged replication

• mehdi rohani

  SSC Rookie

  Points: 25

  More actions

  April 24, 2005 at 6:53 am

  #85868

  i create a merged replication,but the capacity of the log files to be too large.

  my replication process terminated abnormaly and replicate stoped.

  thererof I can not disable replication service.

  the capacity of my database is 2GB.after replicate it was 3GB.

  please guide meeeeeeeee

• Shariq

  SSC Enthusiast

  Points: 107

  More actions

  April 25, 2005 at 9:57 am

  #554638

  Use this hopefully Number 1 would help if not use other;

  --1

   EXEC sp_removedbreplication 'UVMS2'

  --2-Execute the following procedure on the problematic database and pass the table name as the parameter:

  EXEC sp_msunmarkreplinfo 'Dealersetup'

  --3 You may not need this method, but take this as a last resort.

  EXEC sp_configure 'allow',1

  go

  reconfigure with override

  go

  use your_database_name

  go

  update sysobjects set replinfo = 0 where name = 'your_table_name'

  go

  EXEC sp_configure 'allow',0

  go

  reconfigure with override

  go