Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

log_reuse_wait_desc = replication but there's no replication Expand / Collapse
Author
Message
Posted Wednesday, June 26, 2013 5:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 5:28 AM
Points: 2, Visits: 4
waow!!!...this worked like charm
Post #1467565
Posted Wednesday, June 26, 2013 5:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 5:28 AM
Points: 2, Visits: 4
it worked :)
Post #1467568
Posted Thursday, August 15, 2013 8:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 8:30 PM
Points: 1, Visits: 23
Thanks a lot!
Post #1484967
Posted Tuesday, December 16, 2014 11:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 8, 2015 10:20 PM
Points: 281, Visits: 97
I saw this on my SQL server 2008 R2.
I tried removing the replication using "EXEC sp_removedbreplication" but it did not work. In fact I never had replication enabled, althugh there was a plan to do so over the previous weekend. unless some guy in the team tried to set it up and did not clean up properly. He shouldnt be doing this in prod systems
anyways... I ran a checkpoint. My log usage was 95% of 122 GB. It came down to 0.25%.

Post #1644494
Posted Tuesday, December 16, 2014 10:43 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:45 PM
Points: 120, Visits: 184
Hi,

Found a wonderful article on this topic.

# http://blogs.msdn.com/b/repltalk/archive/2010/11/17/how-to-cleanup-replication-bits.aspx

Hope it helps..!!

Regards
Shafat Husain


Regards,
Shafat Husain

And Your Lord Never Forgets...!! (64:19 -- Quran)
Post #1644594
Posted Wednesday, December 17, 2014 4:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 8, 2015 10:20 PM
Points: 281, Visits: 97
Thanks Shafat
I had already cleared it up. I was just inviting for more thoughts. Great link though. keep it up.
Post #1644648
Posted Thursday, January 8, 2015 12:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 8, 2015 11:55 AM
Points: 2, Visits: 43
Gila you are a life safer!!! Thanks!!
Post #1649609
Posted Thursday, January 8, 2015 12:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 8, 2015 11:55 AM
Points: 2, Visits: 43
Thanks so much!!!


GilaMonster (4/10/2009)
Either they were restored from backups of published databases or there was replication at one point and it was removed improperly.

Set the server up for replication, create a publication in the DB in question. Publish any table (not important which one) and then completely remove replication again.
Post #1649610
Posted Tuesday, January 20, 2015 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 8, 2015 3:10 PM
Points: 1, Visits: 19
I tried

sp_RemoveDbReplication
and
ALTER DATABASE SET RECOVERY SIMPLE

Neither worked. Then I tried to right click on replication publisher properties, enabled the db in question as a publisher, hit OK, went there again and disabled, and it finally worked.

Post #1652791
Posted Sunday, February 8, 2015 9:36 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 8, 2015 9:39 PM
Points: 1, Visits: 1
Just set the server up for replication and create a publication in the DB in question.
Post #1658696
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse