Click here to Skip to main content
14,695,235 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have deleted some table rows from a SQL Server 2012 database. Is there a way for me to get these back somehow? If yes, please explain how to do that.

Thanks
Posted

1 solution

There are some options you could try.

If you have backups, you can perform a backup restore like described here. However, without backups it’s not that easy. You can try reading SQL transaction log, but you can do that only if your database was in full recovery model.

You can read transaction log manually by using undocumented functions like DBCC LOG or fn_dblog. Look at this thread for more details:
http://stackoverflow.com/questions/9014531/read-sql-server-transaction-log

Second option is using some third party transaction log readers, e.g. ApexSQL Log.

Another option is to use point in time recovery, but it would undo all other transactions you might want to keep.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900