SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Data File Crashed !!! Could not redo log record
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

cutecode
Starting Member

2 Posts

Posted - 08/24/2004 :  17:25:47  Show Profile
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

United Kingdom
12543 Posts

Posted - 08/24/2004 :  17:27:49  Show Profile  Visit nr's Homepage
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 - 08/25/2004 :  04:16:22  Show Profile
Thanks !!!

It Helped
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000