Urgent: deleted rows recovery

Posted on 2011-04-19
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

    Author Comment

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

    Data base is in transition .

    Does that help?

    Author Comment

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

    Accepted Solution

    Restart management studio and see if you can at least select from the database table again.

    Do you have database backups?

    Author Closing Comment

    Thank you,

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    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…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now