Hi all,

I have got a problem with restoring database using ldf and mdf files
in SqlServer2000

I have got only ldf and mdf files of my database but now that server
was crashed.

I wanted to restore that database onto new server.

I used the following sytax to do that

EXEC sp_attach_db @dbname = N'ykk',
@filename1 = N'd:\ykk\TechBiz_Data.Mdf',
@filename2 = N'd:\ykk\TechBiz_Log.Ldf'

I tried it using sp_attach_db but an error message is stating that

Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\ykk\TechBiz_Data.Mdf' is not a valid
database file header. The FILE SIZE property is
incorrect.

mdf fiesize is 1.84 MB
ldf file size is 1.00 MB.

I request you to help to come out of this problem.

I will be very thankful to you.


Thanks & regards.,
Y.Krishna Kishore
Software Engineer
eSoft Consulting Ltd.
Office: 91-40-3541657 Ext. 306
Fax: 91-40- 3600292
e-mail: ykrishna_kishore@yahoo.com

CONFIDENTIALITY NOTICE : This e-mail transmission and any
document, files or previous e-mail messages attached to it, are
confidential, proprietary and are protected by the work product
doctrine. If you a not the intended recipient or a person responsible for
delivering it to the intended recipient, you are hereby notified that any
review, disclosure, copying, dissemination, distribution or use of any of
the information contained in, or attached to this e-mail is STRICTLY
PROHIBITED. If you have received this transmission in error, please notify
us immediately by forwarding this message to the original sender or by
telephone at 91-40-3541657 Ext. 306 and then delete this message and its
attachments from your computer

Thanks & regards., Y.Krishna Kishore Software Engineer eSoft Consulting Ltd.
Office: 91-40-3541657 Ext. 306 Fax: 91-40- 3600292 e-mail:
ykrishna_kishore@yahoo.com CONFIDENTIALITY NOTICE : This e-mail transmission
and any document, files or previous e-mail messages attached to it, are
confidential, proprietary and are protected by the work product doctrine. If
you a not the intended recipient or a person responsible for delivering it
to the intended recipient, you are hereby notified that any review,
disclosure, copying, dissemination, distribution or use of any of the
information contained in, or attached to this e-mail is STRICTLY PROHIBITED.
If you have received this transmission in error, please notify us
immediately by forwarding this message to the original sender or by
telephone at 91-40-3541657 Ext. 306 and then delete this message and its
attachments from your computer