Microsoft KB Archive/263938

{|
 * width="100%"|

FIX: Logreader May Fail with 9004 Error Message After an Abnormal Shutdown of Publisher SQL Server

 * }

Q263938

-

The information in this article applies to:


 * Microsoft SQL Server version 7.0

-

BUG #: 57711 (SQLBUG_70)

SYMPTOMS
On a publisher, if a Microsoft SQL Server service experiences an abnormal shutdown due to a hardware failure or an access violation, SQL Server might restart fine but the logreader might fail with the following error message:

9004 The log for database %ls is corrupt

You can determine the cause of the abrupt SQL Server shutdown by viewing the previous errorlogs located in the LOG directory of the SQL Server installation path.

NOTE: NOTE: This problem is uncommon and is timing specific.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:

"http://support.microsoft.com/highlights/sql.asp" For more information, contact your primary support provider.

Additional query words:

Keywords : kbSQLServ700bug

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ700