How to recover deleted row on the table in sqlserver 2005

Posted on 2009-04-14
Medium Priority
Last Modified: 2012-05-06
i have a little problem in my company, i accidentally deleted tax data in sqlserver 2005 using query : "Delete from table1" in query analizer, my question is how can i recover data that has been deleted? i have effort using apexsql recover 2008 but the demo version cannot recover all row have been deleted

i really apreciated if someone can help me to solve the problem.. please help me
thank you very much

Question by:Rudy_Rai
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 12

Accepted Solution

udaya kumar laligondla earned 1000 total points
ID: 24136460
one way is to restore a backup if you have one

Assisted Solution

luani earned 1000 total points
ID: 24136891
do you have any backup?
Full Backup?
Diferential or log backup?

Author Comment

ID: 24154018
i dont have any backup for this data .. and this is my fault ...
is there another way for recover this data??


LVL 12

Expert Comment

by:udaya kumar laligondla
ID: 24154052
i am sorry, that looks like a dead end. you can not recover without a backup.

Expert Comment

ID: 37052020

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

719 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