Tuesday, March 20, 2012

data recovery

Hello All,
Is there a way to restore/recover data from an earlier date if you donot hav
e a backup. The data was accidentally deleted from a table.
Thanks in advance
HugoUnfortunately, if you do not have a backup (and more importantly are using t
ransaction 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/in...veral_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 ba
ckup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>

No comments:

Post a Comment