Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sql server 2008 replication clean up log cause dead lock

Posted on 2010-08-20
4
Medium Priority
?
494 Views
Last Modified: 2013-12-08
Does any one know how to resolve sql server 2008 replication clean up log cause dead lock problem.  Must stop the replication each time it happen.
0
Comment
Question by:trungdoung
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:mcv22
ID: 33488630
Replication maintenance jobs are listed below:

http://technet.microsoft.com/en-us/library/ms151232.aspx

You can change the scheduling so that they happen at off-peak hours
0
 

Author Comment

by:trungdoung
ID: 33513814
I am still waiting for a technical soltuion.
0
 
LVL 12

Accepted Solution

by:
mcv22 earned 1500 total points
ID: 33513898
I've seen similar issues on servers I administer and I pretty much have to work around it.

Another similar thread:

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/209a3eb9-dafe-4b9d-a482-617822a4173d?prof=required&wp=MCLBI&lcid=1033&id=254354
0
 

Author Closing Comment

by:trungdoung
ID: 33561359
It is a temp soultion.  Not sure what to do when it happen gain.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question