Transaction Log Restore Error

• psribeiro

  Old Hand

  Points: 390

  More actions

  February 10, 2004 at 6:59 am

  #493368

  Hy Tony !

  I´m having the same problem as you; I posted a question today with the same problem ... Could Not Redo Log Record ....

  I found a answer at Microsoft Knowledge base at http://support.microsoft.com/default.aspx?scid=kb;en-us;831950&Product=sql2k, but when you click at "Resolution" appears a form with "Contact Us Pane" .....

  I don´t know if you have any contract with Microsoft ... If you have any, you could try at this URL and, please CONTACT ME IF YOU HAVE A CLUE 

  []s

  Paulo Ribeiro

   

   

   

• Tony Bater

  SSCrazy

  Points: 2150

  More actions

  February 10, 2004 at 7:18 am

  #493371

  Hi Paulo,

  I checked out that URL, and it does provide an expanation for what happened; between shipping logs I had done some SERIOUS rebuilding work on indexes etc, to fix the original cause of my problem. As I have now resolved the problem myself (by restoring a new complete backup), I guess I will wait for the next SP rather than try to get a hot fix out of Microsoft (I do have a support contract, but is it worth the hassle?)

  
  Tony

• psribeiro

  Old Hand

  Points: 390

  More actions

  February 10, 2004 at 7:51 am

  #493380

  Hi, Tony!

  I´ve been having this problem with high frequency and I always solve as you did: restoring a full backup but; but I have some databases with 30GB and sometimes it takes a long period and spends a lot of net resources to restore it !

  Yes, this URL does not provides a good explanation BUT THERE´S A HOTFIX ! As you have a contract, I´d be very, but very grateful if you contact them and send me a copy

  Thanks,

  Paulo Ribeiro