Post reply

Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE?

  • October 12, 2009 at 8:07 am

    #212165

    I've noticed that my SQL Server log on one of my servers if full of this message.

    Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE

    I looked it up on Microsoft Website and it said it was normal. However, I don't see other items just this one message. I see I have backups, but there is no listing in the log of a backup. Just this one message over and over again.

    Has anyone ever seen this message before that maybe could explain it a bit?

    Just to make sure my backups are good, I'm going to restore the latest today. But it would be good to know what this error message is about.

    Thanks.

    Things will work out.  Get back up, change some parameters and recode.

  • October 13, 2009 at 8:43 am

    #1065228

    Problem solved.

    Someone had turned off the maintenance plan and also turned off DTC. This produced a SQL Server log with no database backup and a log full of the aforementioned message.

    I've resolved the issue.:-D

    Things will work out.  Get back up, change some parameters and recode.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply