Solved

Erro 3456 Could Not Redo Log Record attaching database

Posted on 2004-08-10
3
5,199 Views
Last Modified: 2008-01-09
Hello All,

I'm attempting to attach a database and receiving error 3456: could not redo log record.  

The computer that this database is stored on locked up during an update.  I detached the database and now it won't re-attach it.  I believe that the database has gotten corrupted, but I don't know what my options are?

Any help?

Thanks,

Ben
0
Comment
Question by:benfinkel
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 11763216
Check out this processing, does it help:
http://www.examnotes.net/archive79-2002-10-75559.html

CHeers
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 100 total points
ID: 11763309
Did you see the following articles on MSDN:

FIX: Transaction Log Restore Fails with Message 3456
http://support.microsoft.com/default.aspx?scid=kb;en-us;329487

FIX: Transaction Log Restores May Fail with 3456 Error
http://support.microsoft.com/default.aspx?scid=kb;en-us;295644

FIX: You receive error message 3456 when you try to apply a transaction log to a server
http://support.microsoft.com/default.aspx?scid=kb;en-us;831950

Also, please follow-up on this old open question:
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21025042.html
0
 
LVL 1

Author Comment

by:benfinkel
ID: 11765377
Thanks guys.  The first response fixed my issue, but the second contained some great info to help me in the future and fix it further, so I split the points accordingly.

Thanks again to the both of you!

--Ben
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question