| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-23 : 08:46:48
|
| clarity writes "Dear Support Teams,Can we undrop any table once we mistaken drop it??Any other solution to cover back the drop table without running the restore database?? Pls advice ASAP" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-23 : 09:08:49
|
| No. You need to restore the database, or copy the table from your backup server. This is one of the reasons people have backup servers.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-23 : 09:10:22
|
I am afraid!  It is not possible, without restoring from the backup.- Sekar |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-03-23 : 10:16:05
|
| If you have Lumigent Log Explorer, you can do it. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-23 : 10:31:33
|
| Depends on the recovery model.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-23 : 11:23:15
|
| Why not Create a new database, restore the backup into it, then use SELECT * INTO <tablename> between databases?Raymond |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-23 : 14:24:22
|
quote:
Originally posted by raymondpeacock
Why not Create a new database, restore the backup into it, then use SELECT * INTO <tablename> between databases?Raymond
Raymond, the risk with this approach is that you'll have tables "out of sync" with each other if any additional work has been done on the database. If work has been done, then, depending on the schema and usage, it may be very difficult to re-align them, in which case it would be better to restore the whole database and then reproduce the work done.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-24 : 04:05:45
|
| I agree Mark, but it's a cause of knowing your schema isn't it? Many tables can be restored independantly of other tables in my experience. However there are others as you say where this can't be done.Raymond |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-24 : 20:18:56
|
| Yep, just wanted to raise that topic for the benefit of the original question author to consider.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
S.O.S