Can i restore my deleted rows (by Delete query) in a sqlserver table ?

Question

0.00/5 (No votes)

See more:

SQL-Server

table

Can i restore my deleted rows (by Delete query) in a sqlserver table ????
pls help ..thanks in advance

Posted 16-Mar-13 4:21am

sr_24

Add a Solution

Comments

db7uk 16-Mar-13 10:41am

What is the recovery mode set to on the database? what backup strategy do you have? If none of the above you cant.

[no name] 16-Mar-13 11:03am

No you cannot restore deleted records. You will have to restore from a backup.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Prasad Khandekar · Answer 1 · 2013-03-16T04:41:00

Solution 1

Hello,

Rows deleted can not be recovered after COMMIT operation. If COMMIT is already performed then only way I know to recover data is via database restore provided you have taken a backup before performing this operation.

Regards,

Posted 16-Mar-13 4:41am

Prasad Khandekar

Comments

sr_24 16-Mar-13 10:59am

if i write a simple delete query to delete a record , then Will Commit be performed automatically or i need to do it ....in case such case when i dont use commit , what could be done ??

Prasad Khandekar 16-Mar-13 11:17am

Hello,

What you can do is to soft delete the records. I.e. Add a bit column in your table and set it's value to 1 for deleted records. Your actual query will only retrieve the records with this column value as 0. This way in future if you need to recover the records all you will have to do is to set the column value to 0 for deleted records.

By default autocommit is true and hence if you execute the delete query your records will actually get deleted.

Regards,

Bryce Bates · Answer 2 · 2014-02-13T22:18:00

Solution 3

You might be able to restore your deleted rows.
If your database was in a full or bulk-logged recovery model you could use SQL Server point in time recovery. I suggest reading this post:
http://stackoverflow.com/questions/3540729/how-to-recover-deleted-rows-from-sql-server-table

Posted 13-Feb-14 22:18pm

Bryce Bates