Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Error 3456: could not redo log record (191:5624:2)

Author  Topic
Starting Member

1 Post

Posted - 2006-09-09 : 09:56:50
Microsoft SQL 2000 Developer Edition, SP4

When I try to attach a database I receive the following error message:

Microsoft SQL-DMO (ODBC SQLState: HY000)
Error 3456: could not redo log record (191:5624:2), for transaction ID (0:1598832), on page (1:4562), database 'posTerminal' (12). Page: LSN (191:3919:20), type = 10. Log: OpCode = 2, context 1, PrevPageLSN: (191:5619:2)

I already looked up

But I don't know how to attach as suspect as is described in the article "The first step is to attach the database as suspect..."

Can anybody help me?

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-10 : 07:29:10
What is the root issue? Is your Database corrupted and you want to push Data out of it to another clean Database for Recovery ?
If not can you sustain without the Log file and lose any active transactions inside the log file?

If yes use "sp_attach_single_file_db" and attach just the MDF file and the log file will be recreated for you from scratch.

Rishi Maini
Go to Top of Page

- Advertisement -