|
Posted by Erland Sommarskog on 05/17/07 10:05
Jaroslaw Kozik (jkozik@op.pl) writes:
> I think, my database is strong corupted. Becouse when I try to connect
> database to server I see MSServer error 9004.
Error 9004: "An error occurred while processing the log for database
'%.*ls'." Seems like your log file is hosed.
If you have a recent backup of the database, restore it.
If you don't have a backup, there may be a possibility to recover the
database to some extent, but it is far from certain. Assuming that a
hardware problem thrashed the log file, it could have hit the data
file as well, if the data file is on the same disk. And there is a very
clear risk that there are one or more unrecovered and incomplete
transactions in the database. This means that once you are able to
access it, you may find corruption and/or inconsistences in your data.
If you want to know the steps to do this, please drop me a mail. I don't
want to post this on the newsgroups, because these are commands that
could cause damage if you don't know exactly what you are doing.
Also, you should examine why the log file became corrupted. This could
be a hardware issue, such a faulty disk or a bad memory board.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|