Hi
  Please help

      I was having an sql database on my sql 2000 server machine.The hard disk gets full damaged.Luckily I have latest Backup file,Both .mdf and .log file and also sql script file.
     I installed sql 2000 on another machine now i want to transfer this sql database in this new sql 200 machine

     When I Attach the database to sql server it show following error
error 5172 <path>\mydatabase_log.ldf is not a valid database file header.The pageaudit property is incorrect

Thankx Any Way

Attach the .mdf file, that should automatically find .ldf

Regards
Mujib

I am attaching the same file .mdf file it shows the same error

Hi,

Please try as given below:-
EXEC sp_attach_db @dbname = N'pubs',
   @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
   @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'

Hi Brother
 when i execute
EXEC sp_attach_db @dbname = N'<datbasename>',
   @filename1 = N'<path>\mydatabse.mdf',
   @filename2 = N'<path>\mydatabase_log.ldf'
It show following error:
 <path>\mydatabase_log.ldf is not a valid database file header.The pageaudit property is incorrect

Please Help I am In Trouble

Check this :: http://searchdatabase.techtarget.com...%2Fpr%2F286331

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

I have gone through these sites but there is still same error

Any Way Thankx
Please Help

I want help Please Help Me

I think you should restore your master db first and then try sp_attach_db, if it does not, try sp_attach_single_file

but when i restore master db sql server does not start it shows error

sql server does not exists or access denied