Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Server Transaction Log Files
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01320836
Message ID:
01320838
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform