| Author |
Topic |
|
automicgina
Starting Member
25 Posts |
 Posted - 2003-07-29 : 11:08:41
|
| Hi, I ran a delete statement and deleted 200 records by mistake. Is there a rollback statement that can restore the records? or they are gone for good? Please help. Thanks! |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-07-29 : 11:22:43
|
| if you dont have lumigent explorer installed on your server. am afraid you can get them back, unless ofcourse if you have a backup of the data.-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-29 : 12:27:24
|
| If your recovery model is set to FULL, then you can still backup the transaction log. Then you would have to perform a restore from a full backup that occurred prior to the transaction log, then perform a restore of the transaction log but using a point in time recovery. You would not want to restore over your database, but rather restore it to a different name. After the restore to a point in time, you can then extract your records from this new database into your other database. But all of this requires the recovery model to be set to FULL.Tara |
|
|
|
automicgina
Starting Member
25 Posts |
Posted - 2003-07-31 : 11:05:32
|
| Thank you both for the advices. Just found out the recovery was set to Simple. So no hope? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-31 : 12:53:51
|
| Yep, no hope.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-31 : 13:24:33
|
| Start typing....Or if you're simple (the databse recovery model, not the dba), did you take a back last night.Can you restore that somewhere and see if they're in it?Just a thought.Tara, what'dya think?Brett8-)SELECT POST=NewId() |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-31 : 13:31:26
|
Just have to love Lumigent Log Explorer... It saved my butt a couple of months ago when one of my colleagues accidentally deleted everything from a production table...  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-31 : 13:37:37
|
| Log Explorer would only help if your recovery model was set to FULL.Yes if automicgina had a backup that occurred before the DELETEs, then those rows might be in there, just depends on when they were created. I kinda figured that he/she was asking about a rollback because no database backups exist.Tara |
|
|
|
automicgina
Starting Member
25 Posts |
Posted - 2003-07-31 : 14:55:29
|
| Right tduggan, I don't have any backup. Cost me 2 working days to reenter the records.....I've learned so much from everyone here. Thanks! |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-31 : 16:42:00
|
| That's a good way to learn...you will NEVER have that problem againI would wage money on it....Brett8-)SELECT POST=NewId() |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-31 : 16:44:29
|
| I've actually done quite a few dumb things in production. Being a DBA, you have a lot of power; being human, you make mistakes. Luckily I've always had backups to undo my mistakes. I probably won't ever make the same mistake in production, but there's always some other mistake to be made.Tara |
|
|
|
|
delete records by mistake. Rollback possible?