MICROSOFT SQL-DMO ERROR 5172

Discussion:

(too old to reply)

ashraf_al_ani via SQLMonster.com

2010-07-06 07:41:58 UTC

Dear All
I am trying to attach the database so when i press attach
ive got this error MICROSOFT SQL-DMO (odbc sql state 42000)
ERROR 5172 :the header file for e\salary_log.ldf is not a valid databse file
header the page audit property is incorrect

please any idea???

best regards

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201007/1

Erland Sommarskog

2010-07-06 09:06:02 UTC

Permalink

I am trying to attach the database so when i press attach ive got this
error MICROSOFT SQL-DMO (odbc sql state 42000) ERROR 5172 :the header
file for e\salary_log.ldf is not a valid databse file header the page
audit property is incorrect
please any idea???

Which version of SQL Server does the supposed database file comes from?

Which version do you try to attach it on?

You can't attach a file from a higher version of SQL Server on a lower
version.

--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

e***@gmail.com

2014-08-26 10:54:48 UTC

Permalink

Please read this blog, it simply explain that how to attach sql database after it show error 5172. http://www.sqlrecoverysoftware.net/blog/sql-error-906.html