How to using .LDF file to restore the DB ?

Dear All:
I have heard about only one .LDF can restore to my need DB status,
but it's not document in any manual, somebody could tell me how to
do it?
My status is I lost my .MDF file, but .LDF is alive, I want to restore
to one old day (say YYYYMMDD), how to write the T-SQL?
Regards.Ahah
Check it out
http://www.officerecovery.com/mssql/
I have no idea how does it work ,never used it.
"Ahan Hsieh" <ahan@.ms61.url.com.tw> wrote in message
news:eD$fLgFyDHA.4064@.tk2msftngp13.phx.gbl...
> Dear All:
> I have heard about only one .LDF can restore to my need DB status,
> but it's not document in any manual, somebody could tell me how to
> do it?
> My status is I lost my .MDF file, but .LDF is alive, I want to restore
> to one old day (say YYYYMMDD), how to write the T-SQL?
> Regards.
>|||I'm sorry, that is not possible. Don't you perform backup for the database?
You could look at log readers, for instance www.lumigent.com, but the
information you need is most probably not available in the ldf file
anymore...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ahan Hsieh" <ahan@.ms61.url.com.tw> wrote in message
news:eD$fLgFyDHA.4064@.tk2msftngp13.phx.gbl...
> Dear All:
> I have heard about only one .LDF can restore to my need DB status,
> but it's not document in any manual, somebody could tell me how to
> do it?
> My status is I lost my .MDF file, but .LDF is alive, I want to restore
> to one old day (say YYYYMMDD), how to write the T-SQL?
> Regards.
>