restore deleted records

Hi i am currentlly using the SQL sever 2000, i am
wondering is there anyway to restore back the deleted
records which i had deleted at the SQL server table with
the default configuration?
Help it's urgent!!
Thanks...
Regards
sharonSHARON wrote:
> Hi i am currentlly using the SQL sever 2000, i am
> wondering is there anyway to restore back the deleted
> records which i had deleted at the SQL server table with
> the default configuration?
> Help it's urgent!!
> Thanks...
> Regards
> sharon
As long as you are not running simple recovery mode you can use
Lumigent Log explorer to do this http://www.lumigent.com/
Otherwise the only way would be to restore your latest backup.
p.s. if you arent using simple recovery mode and perform regular
transaction log backups you could also restore to a point in time.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============