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 |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2005-09-12 : 10:35:28
|
| I accidently deleted my table. Is there any way I can get back my deleted data. I have not done any backup. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-12 : 10:39:56
|
| If you have not backup then it is not possibleIf you have used Begin Trans then you could rollback itMadhivananFailing to plan is Planning to fail |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2005-09-12 : 10:48:11
|
| If db uses full recovery model, you may be able to recover the table. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 10:48:30
|
maybe you should check out your transaction logs if you have any?Go with the flow & have fun! Else fight the flow  |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-09-12 : 10:53:09
|
| It's a good time to setup some backups, now that you discovered why you need them.CODO ERGO SUM |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-09-12 : 15:13:50
|
| If your DB is full recovery, you still need a good backup and all the transaction log(s) to recover back to the point in time before the deletion. If you have a product such as Lumigent's "Log Explorer" installed, you can read your transaction logs and then build a script to "undo" your deletes. |
|
|
|
|
|
|
I have deleted my table