RestoreToStandBy => #Error 3456 (Could Not Redo Log Record)

  • Hi Gurus!

    Could you please help me with this error ?

    Could not redo log record (76912:8788:6), for transaction ID (0:403475013), on page (1:1401175), database 'dbProducao' (12). Page: LSN = (76912:1485:2), type = 1. Log: OpCode = 4, context 2, PrevPageLSN: (76901:2565:24). [SQLSTATE HY000] (Error 3456)  20 percent restored. [SQLSTATE 01000] (Error 3211)  40 percent restored. [SQLSTATE 01000] (Error 3211)  60 percent restored. [SQLSTATE 01000] (Error 3211)  80 percent restored. [SQLSTA...  The step failed.

    I found that Microsoft has a hotfix at http://support.microsoft.com/default.aspx?scid=kb;en-us;831950&Product=sql2k , but when I click at Resolution it shows the "Contact Us" pane ...

     

  • Ops, I forgot to say that my environment is

    Microsoft SQL Server  2000 - 8.00.780 (Intel X86)  ===> sp3a

     Mar  3 2003 10:28:28

     Copyright (c) 1988-2003 Microsoft Corporation

     Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    As you can see I´ve all patchs installed.

    Thanks,

  • The fix has newer version (878) of sqlserver.exe than what you have.

    11-Nov-2003  20:34  2000.80.878.0   7,606,353  Sqlservr.exe

    Call PSS at microsoft to get it. It should be free of charge.

     

     

  • OK, Allen but I do not have a support contract and I confess you that I gave up of asking for free support at Microsoft because they never answered me

Viewing 4 posts - 1 through 3 (of 3 total)

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