Solved

sql server 2008 replication clean up log cause dead lock

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This Micro Tutorial will demonstrate how to add subdomains to your content reports. This can be very importing in having a site with multiple subdomains.

914 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now