Recover data after using delete statement

Help.. I Just deleted some records a table in sql 2000. Tell me how to
recover the records.
ThanksWhat types of backups do you have?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Le Thuan" <LeThuan@.discussions.microsoft.com> wrote in message
news:51E07AEF-9549-415A-B098-F9C36E7778EA@.microsoft.com...
> Help.. I Just deleted some records a table in sql 2000. Tell me how to
> recover the records.
> Thanks|||Hi,
If the recovery model is other that simple you could recover your data by
using an utility called Log Analyzer (google it). If you have some backup
strategy which imply log backup than do a restore process with stop at clause.
Tibor Karaszi wrote:
>What types of backups do you have?
>> Help.. I Just deleted some records a table in sql 2000. Tell me how to
>> recover the records.
>> Thanks
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200708/1|||I don't have any backups
"Tibor Karaszi" wrote:
> What types of backups do you have?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Le Thuan" <LeThuan@.discussions.microsoft.com> wrote in message
> news:51E07AEF-9549-415A-B098-F9C36E7778EA@.microsoft.com...
> > Help.. I Just deleted some records a table in sql 2000. Tell me how to
> > recover the records.
> > Thanks
>|||Then the data is most probably gone. You could try a log reader program, but I doubt that the
information is still in the transaction log.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Le Thuan" <LeThuan@.discussions.microsoft.com> wrote in message
news:711D861E-95F9-458A-A79F-295C7FA3C14C@.microsoft.com...
>I don't have any backups
> "Tibor Karaszi" wrote:
>> What types of backups do you have?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Le Thuan" <LeThuan@.discussions.microsoft.com> wrote in message
>> news:51E07AEF-9549-415A-B098-F9C36E7778EA@.microsoft.com...
>> > Help.. I Just deleted some records a table in sql 2000. Tell me how to
>> > recover the records.
>> > Thanks
>>