Restore DB table - SQL Server 2000

28 Feb 2006 1:06 PM

darren.daniel

Hi,

I made a release on system at 12pm 22/02 and overwrote a table by
mistake.

I have a back from from the night before (12 at night) but from the
time I did a backup and and the time I did the release some records
would be lost.

I want to recover the data lost.

Can I examine the transaction logs to get back the data?
Is there a tool in SQL server to do this or is there a free one?

TIA,
Darren

28 Feb 2006 4:33 PM

Tibor Karaszi

This was replied to in another group. Please don't multipost.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

<darren.dan***@iclployalty.com> wrote in message

Show quote

news:1141131966.097622.3760@p10g2000cwp.googlegroups.com...
> Hi,
>
> I made a release on system at 12pm 22/02 and overwrote a table by
> mistake.
>
>
> I have a back from from the night before (12 at night) but from the
> time I did a backup and and the time I did the release some records
> would be lost.
>
> I want to recover the data lost.
>
> Can I examine the transaction logs to get back the data?
> Is there a tool in SQL server to do this or is there a free one?
>
> TIA,
> Darren
>