Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-26 : 10:41:01
|
| Rajendra Prasad writes "I accidentally deleted a set of records in a table through query analyzer. Is there any way to retrieve those deleted records ?? Please suggest any solution for this as soon as possible. Thanks in advance" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2002-12-26 : 10:52:06
|
| If you are making backups, you should be able to restore those records from your backup. Is this a relatively static table or transactional?Mike"oh, that monkey is going to pay" |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-26 : 19:06:39
|
| If you don't have a backup there is a tool by lumigent that might be able to help you.http://www.lumigent.com/ |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-12-26 : 23:31:52
|
| Doubtful.SQL Server is not like a Windows desktop, you don't have a "recycle bin". You have to be careful before deleting data.Some suggestions for next time :1. Backups backups backups2. For some data, it can be preferable not to delete it at all, instead, have a status column that marks the data as active or deleted. That way you can always find it if you need to.Damian |
|
|
|
|
|
|
Retrieval of deleted records