Hi
If u have any full backup and the recovery mode is
full, perform following tasks:

Take transaction log backup of the database.

Apply the RESTORE DATABASE using following syntax:

RESTORE DATABASE DB Name
FROM disk='full backup path'
WITH NORECOVERY
GO
RESTORE LOG DB Name
FROM Disk='Transaction Log backup path'
WITH RECOVERY, STOPAT = 'specify the point in time
till u want to recover the data' for e.g.
Nov 1, 2003 11:30 AM'

Switch the database in a single user mode.

Hope this will work.

Do revert back in case of any concerns.

Regards
Mandeep



--- Prakash <[Email Address Removed] wrote:
> dear gurus
> by mistake my cooligue has dropped a table which was
> having 100 critical
> record.I dont have backup which includes this
> table.How can i get this
> table.
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
MS Sql Server LazyDBA home page