2

Need to roll back a delete operation from the transaction logs in sql server 2008 but unsure how to do this.

Can anyone give me a point in the right direction for the correct syntax for this operation??

I'd be very grateful,

Thanks

109221793
  • 16,477
  • 38
  • 108
  • 160

2 Answers2

1

There is no way to do this using MS provided tools in SQL. Apex has a log utility http://www.apexsql.com/sql_tools_log.asp will likely sort your issue. If you can't get that then restoring is your best bet.

u07ch
  • 13,324
  • 5
  • 42
  • 48
0

the only supported way is to restore from backup.
if you want to go crazy you can do something like this

but i'd suggest you take a backup before attempting anything like that.

Mladen Prajdic
  • 15,457
  • 2
  • 43
  • 51