Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: Failed to obtain TransactionDispenserInterface and invalid LSN, databases suspect

    All of a sudden I have 4 of my databases, including pubs that are all marked suspect and seem to be un-recoverable. I have followed the Resetting the suspect status directions as well as trying to attach only the .mdf files but still run into problems reading the .ldf file. I have not tried to do the procedure of creating another database with the same name and structure then swapping the files to trick SQl but will do so if I need to. Does anyone know why this happens all of a sudden to multile databases, of which Pubs I have never used for anything??

    In my log files during startup I get this error

    Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

    Then this error for every database that is suspect, (the actual LSN numbers are different for each one).

    The LSN (4:517:1) passed to log scan in database 'pubs' is invalid..
    Is there anything else I can do to prevent this from happening or recover the DB's

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Failed to obtain TransactionDispenserInterface and invalid LSN, databases suspect

    The log file is corrupted. The only good prevention is to have a good backup strategy. You need to look at whether your .mdf is also corrupted or not.

  3. #3
    Join Date
    Oct 2003
    Posts
    57
    Why would these become corrupted? Should I look for a SQL problem or a disk error??.... Do you know the best way to track this?? I found it odd that 4 databases would end up like this at the same time

    Thanks

Posting Permissions

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