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 |
|
aravindt77
Posting Yak Master
120 Posts |
 Posted - 2009-11-16 : 08:52:24
|
| hi,By mistake dropped a table in the production server with more than lacs of data... any way to recover it ... ( table dropped using drop statement)plz guide me...Thnks !!! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-16 : 09:17:31
|
| restore most recent backup to new database and copy the table from there. are you taking tran log backups? |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-17 : 06:36:07
|
| Take the Backup of the Transaction Log and then restore that Transaction log backup to the Point in Time ( just before the drop statement)First Restore the Full Backup with No recoovery optionthen restore the Transaction Log backup at Point in Time (Before Drop) with Recovery option |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-17 : 07:32:37
|
Do you have a backup (Jim)?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Recover dropped table in live db