Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Urgent: deleted rows recovery

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
Hello experts,

In a SQL 2005 database, I have run this script by mistake:

Delete from table1
Delete from table2
Delete from table3

And after 4 seconds, and while script was still running, I clicked the red sqaure (Stop).

Now the database is inaccessible, I will not make any other action untill I will receive your comment.

Is it possible to recover the deleted rows? Can I make Rollback as in Oracle?

My database is working in the Simple recovery mode.
Question by:Muhajreen
  • 3

Author Comment

ID: 35425362
When I am trying to open a table I am getting this message:

Data base is in transition .

Does that help?

Author Comment

ID: 35425384
Sorry, forgot to tell you that after I stoped the deleted script, I tried to take the database offilne, but I canceled it also.

Accepted Solution

hyphenpipe earned 2000 total points
ID: 35426107
Restart management studio and see if you can at least select from the database table again.

Do you have database backups?

Author Closing Comment

ID: 35427166
Thank you,

I have deatached the DB files and attached them again, and found that now single row was deleted !

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Loops Section Overview
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question