>Hi.
>Is there a way to View Transaction log files , or 'Roll Back' transactions from a Log File.
>For instance , just did a "Delete from MyTable where 1=1 " in SSMS and it deletes all records. Now in VFP, I could recover deleted records , but in SQL the only way I can think of recovering them is possibly via Transaction Log.
>
>I cant see anywhere though where I can View Transactions Log or Recover deleted records .
>
>Any help appreciated .
>regards,
>Gerard
You need to use Restore to the Point of time option.
If it's not broken, fix it until it is.
My Blog