2

Today, for a great oversight, did a deal with a big mistake, which I forgot to put the WHERE keyword in the UPDATE statement... I searched in the google, I found a lot of things of how to restore the database ( FROM BACKUP ), but the backup was done daily database simply disappeared :(

Now, the only information I have remaining is the log file of SQL, I found the ApexSQL log, that program make a SQL undo script, but, just for a 10th process... I have 2024 to restore, and, I don't want to pay U$ 1.5k for this program, now, I want to know, how I can restore the informations, have a FREE program to make this ?

Alexandre
  • 121
  • 1

1 Answers1

2

There is no free tool to do this. Basically, your only other option is to restore a backup. For that you need to have made a full backup of the database. If you have one, you can recover your table at the time of your full backup by restoring it into another database, and copy the table back to your original database.

Plus, if your database is in full recovery model, you can backup your transaction log and try to restore it after the full backup restore and other transaction log backups that you might have taken in between if you have a backup plan. So, do you have backups of your database, and when were they taken?

rudi bruchez
  • 197
  • 2
  • 8