Help! Emergency

Hi,
I have an issue, Someone ran an update query on the server and I need to
reverse the effect. How can I do this.
Thanks
JEither backup the transaction log, restore the last backup and reapply =
transaction logs up to just before the unwanted update,or restore the =
most recent backup to a separate db and copy the offending table to your =
real db - if this is acceptable,
or buy something like log explorer from lumigent.
Sorry but thats the only choices.
Mike John
backup
"JD" <jk_50@.hotmail.com> wrote in message =
news:Of9lU2SOEHA.892@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have an issue, Someone ran an update query on the server and I =
need to
> reverse the effect. How can I do this.
>=20
> Thanks
>=20
> J
>=20
>|||Hi,
The point_in_time restore is possible only if your database recovery moel is
set to "FULL". If it is full you can perform the below steps:-
1. Do a transaction log backup in current database
2. Restore the full database backup to a new database with norecovery option
3. restore the subsequent trasnaction log abckup to new database with
norecovery till the last backup
4. restore the final trasnaction log backup with STOPAT option mentioning
the time , RECOVERY
This will recover the new database till the time you mentioned.
Thanks
Hari
MCDBA
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:#ynRW6SOEHA.1620@.TK2MSFTNGP12.phx.gbl...
Either backup the transaction log, restore the last backup and reapply
transaction logs up to just before the unwanted update,or restore the most
recent backup to a separate db and copy the offending table to your real
db - if this is acceptable,
or buy something like log explorer from lumigent.
Sorry but thats the only choices.
Mike John
backup
"JD" <jk_50@.hotmail.com> wrote in message
news:Of9lU2SOEHA.892@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have an issue, Someone ran an update query on the server and I need
to
> reverse the effect. How can I do this.
> Thanks
> J
>