Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: distributed transaction resolution is not complete yet

    Hi,

    I am getting below error while running:

    dump transaction master with truncate_only


    Msg 4237, Level 16, State 1
    Line 1:
    Cannot dump master database's log as distributed transaction resolution is not complete yet. Please retry later.

    what could be the reason pl

    thanks in advance

    -Ram

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    This is a guess: the transaction needs to be replicated on all the remote servers before it completes. If one of the remote servers is down (or log might be full) then the transaction can't be completed on that remote server and the main transaction will not be complete. Can you check each of the remote servers to check that they are up and the log isn't full.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •