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 |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2007-05-16 : 03:11:03
|
Hi all,I have some problem :I use sql server 2000,I have about 20000 records !I delete all data unfortunately !So , i need to restore all .Are there way to do this ? I don't setup automatic backup !  My data is very important !Thank you very much. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-16 : 03:24:42
|
| There are only two options:1. If you had your delete operation inside Transactions and haven't committed yet, fire a Rollback statement2. Restore latest backupHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-16 : 09:59:20
|
| Another option is recover them with third party tools. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-16 : 15:47:16
|
| I've seen this type of message posted before.I wish people would say "I set up an automated backup, and tested it, but I made a mistake and when I needed the backup it wasn't useable. That I would have HUGE sympathy with.This:"I don't setup automatic backup...My data is very important"I have very little sympathy with - unless I have misunderstood "I don't setup automatic backup" and actually it is "I took backups but they are not useable"Kristen |
|
|
|
|
|
|
Lose Important Data