I believe there should be a way to restore your database to the point of time if you use FULL Recovery model. That's the whole point of using it.
>>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