Wednesday, March 28, 2012

Restore DB - SQL Server 2000

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?
What would I need to do?
TIA,
Darren
So ,have you done BACKUP LOG file?
If yop do , just apply all log'd backups WITH NORECOVERY option except the
last one
Visit at Tibor's web site to find a greate example ,how to restore a
database at point of time
<darren.daniel@.iclployalty.com> wrote in message
news:1141131856.938247.59340@.z34g2000cwc.googlegro ups.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?
> What would I need to do?
> TIA,
> Darren
>

No comments:

Post a Comment