0

I accidentaly ran a delete command against all data from table with a wrong command.

I am using SQL Server 2017.

Is there a way that could help me recover the lost data?

Mahmoudi MohamedAmine
  • 230
  • 1
  • 3
  • 13
  • 2
    Did you commit the changes? If not, you can issue a `rollback;` command. If yes, I hope that you have a backup of your database... – GMB Oct 25 '19 at 21:48
  • 2
    Do you have back ups..? If not, you're effectively out of luck. – Thom A Oct 25 '19 at 21:48
  • 1
    Hopefully you have a backup. – Eric Oct 25 '19 at 21:50
  • 2
    If you don't have a back up, then learn from your mistake, and start taking **regular** backups. This is but one reason of many on *why* backups are so important. – Thom A Oct 25 '19 at 21:59

0 Answers0