recovery

Question

Post reply

recovery

Mike Levan

SSChampion

Points: 14201
More actions
December 3, 2008 at 11:28 am

#132540

I have deleted a table from a database and has no backup.how can i recover it again? any chances??

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

No chance. If you don't have a backup, it's gone.

Greg

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

It might be possible if you once took a full backup, and the recovery model is FULL using one of the Log Reader programs like ApexSQL Log, but these cost $1K for a license. If you have never done a backup, or you are in Simple recovery, you have lost that table. Backups should be the first thing you implement for any database.

Mike Levan SSChampion Points: 14201 More actions · Answer 3

Mike Levan

SSChampion

Points: 14201

December 4, 2008 at 6:49 am

#907536

what if i had a detacched database?

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 4

If it is a detached copy of the same database, you could attach it with a different name and get a copy of the table and whatever contents existed at the time it was detached. Unless you did the detach/copy immediately before doing the drop of the table, you will still have data loss.