Prev: resource allocation for different query
Next: select max time in AM
From: ashraf_al_ani via SQLMonster.com on 6 Jul 2010 03:41
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

From: Erland Sommarskog on 6 Jul 2010 05:06
ashraf_al_ani via SQLMonster.com (u54845(a)uwe) writes:
> 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, esquel(a)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

 | 
Pages: 1
Prev: resource allocation for different query
Next: select max time in AM