Thanks to all.

thanks a lot.... for... getting back on that one.... ???

When I have checked the database.............. today

it is actually "in full recovery mode" and it's compatibility version is SQL 2000 (80)

It...

thanks a lot Mr. Gail

Last question on this...........

If the DB was in FULL Recovery mode........... and if they had copied.. .mdf and .ldf files to some other location.

is there any...

I am not a DBA ...

My company doesnt hire any DBAs, I am just an SA... that too for 25 + sites

I have four stupid assistants with me.., they are...

Can Red Gate Log Explorer work..... ???

if I downgrade the database to SQL 2000 (compatability 80)

and try to recover from then ...........

Is it possible to to downgrade from SQL...

the data belongs to transactions of savings accounts

of a low level branch, (the low level branch is a non computerised office)

the records of that low level branch are being managed...

assuming that if there was a full backup of the db

what should I do to recover upto a LSN number

then what is the use of point-in-time recovery

I can see all the lsn Numbers in the 'DBCC LOG(aknagar)'

where it is showing all Delete Actions performed.

I dont know how actually this...