Thanks a lot to all.

Austin

If you remove the where clause in given script then it will display the information about transaction log file coz' the file id of .mdf file is 1 and fileid...

Thanks for the script..

I used the script successfully which u have posted with little bit of editing coz' I am using SQL 2005 environment.

Thanks a lot...

Regards,

Austin

No I don't have script that is the reason I am looking for somebuddy who can help me.

Hi Nita,

I think it's an issue of collation seeting....

Thanks for reply,

There are no columns in the table which show history inf.

I think the best solution is to create the script for the objects which has been created after...

Thanks John,

So according to you I'll not able to recover last 25 min data

Regards,

Austin