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 |
|
born2acheive
Yak Posting Veteran
65 Posts |
 Posted - 2006-12-29 : 03:18:48
|
| hi, is it possible to recover the dropped table?if means please tell me how. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-29 : 03:51:45
|
| Restore from a backup. Unless you are using database snapshots in SQL Server 2005, or you ran a SELECT ... INTO to another table before dropping the want you want to get back, you won't be able to get the table back without restoring from a backup.You can restore a backup temporarily to another database name, then copy the table from the restored database to the existing database and drop the restored database. |
 |
|
|
born2acheive
Yak Posting Veteran
65 Posts |
Posted - 2006-12-29 : 03:59:28
|
| hi snSQL,thankyou |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-29 : 08:08:13
|
| snSQL's suggestion is applicable only when you were careful enough to maintain regular database backups before doing nasty things like dropping table.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
drop table