Solved

How to recover deleted row on the table in sqlserver 2005

Posted on 2009-04-14
6
924 Views
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

regards,
Felix
0
Comment
Question by:Rudy_Rai
6 Comments
 
LVL 12

Accepted Solution

by:
udayakumarlm earned 250 total points
ID: 24136460
one way is to restore a backup if you have one
0
 
LVL 7

Assisted Solution

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

Author Comment

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

Regards,

Felix
0
 
LVL 12

Expert Comment

by:udayakumarlm
ID: 24154052
i am sorry, that looks like a dead end. you can not recover without a backup.
0
 
LVL 9

Expert Comment

by:mimran18
ID: 37052020
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL HELP 2 87
MessageHandler Database in SQL way too large 4 45
Record open by another user 6 58
How to query LOCK_ESCALATION 4 41
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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