• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

sql server 2008 replication clean up log cause dead lock

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
trungdoung
Asked:
trungdoung
  • 2
  • 2
1 Solution
 
mcv22Commented:
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
 
trungdoungAuthor Commented:
I am still waiting for a technical soltuion.
0
 
mcv22Commented:
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
 
trungdoungAuthor Commented:
It is a temp soultion.  Not sure what to do when it happen gain.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now