|
Home > Archive > MS SQL Server > February 2006 > Restore DB - SQL Server 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restore DB - SQL Server 2000
|
|
| darren.daniel@iclployalty.com 2006-02-28, 8:23 pm |
| 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
| |
| Uri Dimant 2006-02-28, 8:23 pm |
| 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.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?
> What would I need to do?
>
> TIA,
> Darren
>
|
|
|
|
|