Restore from transaction log 1

[Azzuri]

Hi,

A delete was just performed on one of our tables deleting all data for a specific day. Is there any way to restore the data from the transaction log. We are using SQL server 7 on WINNT server. Please let me know if you have any suggestions.

Thanks,

 

[SQLBill]

You cannot restore just part of the database. You must restore the whole thing.

-SQLBill

 

[Azzuri]

Sorry, does this mean I can still retrieve the data by restoring the database to how it was before the information was deleted or is it gone. If I can retrieve the data, how do I go about doing so.

Thanks for your help.

 

[SQLBill]

Do you have a full backup?

If so, first run RESTORE BACKUP command using the option WITH NORECOVERY.

Then run RESTORE LOG with the options WITH STOPAT and the date and time you want the log to restore to and don't forget to use WITH RECOVERY.

Refer to the Books OnLine, use the Index tab and enter RESTORE BACKUP, then check out RESTORE LOG.

-SQLBill

 

[Azzuri]

Thanks for the help SQLBill. I found what I needed.