restoring one particular table

Hi All,
I am taking transaction log backup every six hours. How do
i restore one particular transaction log from which i can
get the table back.How can i go about pls help me as its
very urgent.
TIA
RegardsYou can't restore a single table from a transaction log backup. Is that
specifcally what you're asking to do? You might want to look at LogExplorer
from www.lumigent.com if you need to reconstruct a single table...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Adil" <anonymous@.discussions.microsoft.com> wrote in message
news:03ea01c3baaf$2c6e38d0$a301280a@.phx.gbl...
> Hi All,
> I am taking transaction log backup every six hours. How do
> i restore one particular transaction log from which i can
> get the table back.How can i go about pls help me as its
> very urgent.
> TIA
> Regards
>|||Without the third party tool that Brian mentioned, you would typically
restore the database to a second location (different database name) and DTS
the table you want back into production.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Adil" <anonymous@.discussions.microsoft.com> wrote in message
news:03ea01c3baaf$2c6e38d0$a301280a@.phx.gbl...
> Hi All,
> I am taking transaction log backup every six hours. How do
> i restore one particular transaction log from which i can
> get the table back.How can i go about pls help me as its
> very urgent.
> TIA
> Regards
>