Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to recover the old data from table

Tags:

sql-server

I have made an update statement in a table in SQL 2008 which updated the table with some wrong data.

I didn't have a backup for the database.

It's some important dates which got updated.

Is there anyway where I can recover the old data from the table?

like image 766
SNA Avatar asked Nov 21 '25 04:11

SNA


1 Answers

Basically no unless you want to use a commercial log reader and try go through it with a fine tooth comb. No backup of the database can be an 'update resume, leave town' scenario - harsh but it just should not happen.

like image 82
Andrew Avatar answered Nov 24 '25 23:11

Andrew