The header for file"dbname_log.ldf" is not a valid database file header

• steve.ahn71

  SSC Journeyman

  Points: 93

  More actions

  August 5, 2012 at 1:54 pm

  #279232

  Please help me with this problem.

  SQL 7.0

  I copied both ldf and mdf file after shutting down the SQLServer because of HDD failure.

  SQL 7.0 server on new computer won't attach the db with following error.

  [Microsoft][ODBC SQL Server Driver][SQL Server] The header file for the "D:\database\dbname.ldf" is not a valid database file header. The pageAudit property is incorrect.

  Thanks in advance.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  August 6, 2012 at 12:41 am

  #1521837

  Are you using UI or sp_attach_db?

  Please post the query you are using.