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 ««12

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: Wednesday, December 17, 2014 4:12 AM
Points: 281, Visits: 94
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 70, Visits: 96
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
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: Wednesday, December 17, 2014 4:12 AM
Points: 281, Visits: 94
Thanks Shafat
I had already cleared it up. I was just inviting for more thoughts. Great link though. keep it up.
Post #1644648
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse