data recovery

Hello All,
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table.
Thanks in advance
Hugo
Unfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.
|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
sql