Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
narguelloc@hotmail.com
Starting Member
1 Post |
Posted - 2006-09-09 : 09:56:50
|
Microsoft SQL 2000 Developer Edition, SP4When 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 http://www.nigelrivett.net/RecoverCorruptDatabase.htmlBut 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.ThanksRishi Maini |
|
|
|
|
|