Solved

sql server 2008 replication clean up log cause dead lock

Posted on 2010-08-20
4
488 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 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Google currently has a new report that is in beta and coming soon to Webmaster Tool accounts. This Micro Tutorial will highlight new features for Google Webmaster Tools.

809 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