I have a Sql Server Transaction Log file that was corrupted from a power
failure. Can someone help me with ideas of how to recover it please. (MS SQL
SERVER 2000).
Thanks.

Kissi Asiedu (kissi5559 (AT) aol (DOT) com) writes:
If you want to recover the log file as such, your prospects are very
poor. Open a case with Microsoft to find out whether it is at all
possible.

If you want to recover the database, your odds are somewhat better, but
they are not good. If you have a clean backup, restore it.

If you want to be able to access the database to get as much data as
possible, that may be doable, but it's far some certain. In such case
you would access a database with uncommitted transactions, which means
that you could face corruption as well as data inconsistency.

How do to this on SQL 2000 requires use of undocumented command that I
rather not share in public. (On SQL 2005, the process do this is
documented.) Please mail me for details.

But keep in mind: if you have a clean backup, restore it.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx