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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Data File Crashed !!! Could not redo log record

Author  Topic 

cutecode
Starting Member

2 Posts

Posted - 2004-08-24 : 17:25:47
My server crashed unpredictably and after rebooting the server
I cannot mount my database file.

The Sql Server says:
"Microsoft SQL - DMO (ODBC SQLSATRE: HY000)
Error 3456: Could not redo log record (238735:1315:1), for trunsaction ID
(0:99832840), on page(1:315980), database saprykin (7). Page ...

Is thear any way to restore my data ?
I have trunsaction log, but I dodn't have a back up copy.

nr
SQLTeam MVY

12543 Posts

Posted - 2004-08-24 : 17:27:49
What stateis the datatbase in?

see
http://www.nigelrivett.net/RecoverCorruptDatabase.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

cutecode
Starting Member

2 Posts

Posted - 2004-08-25 : 04:16:22
Thanks !!!

It Helped
Go to Top of Page
   

- Advertisement -