March 26, 2009 at 11:46 pm
Can any one suggest me how recover deleted table in a database..uncertainly i have wrongly use the drop command..
Plz give ur oppinion..
March 27, 2009 at 12:28 am
1) Take T-Log backup of Transaction log of the database in question.
2) Restore the most recent full backup to another database name on server.
3) Restore any Diff/T-Log backups you have.
4) Restore your T-Log backup you took in #1 with STOPAT with time frame right before you did delete.
5) Copy the table over from the new database back to original database.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 27, 2009 at 4:58 am
t.ranjith (3/26/2009)
Can any one suggest me how recover deleted table in a database..uncertainly i have wrongly use the drop command..Plz give ur oppinion..
Is this a Production or Test environment? Restore it as advised to the desired point of time.
March 27, 2009 at 10:37 am
Hi Ranjit,
The restoration of your deleted table depends upon the multiple points. Hope your database is in Full Recovery mode. If it is in simple recovery mode, the chances of table recovery is limited.
Hope you have periodic backup schedule in place. It needs last full backup, latest diffrential backup (if any) and then all Transaction Log backups.
If everything from backup is in place, you can do a point on time recovery to get your table back.
March 27, 2009 at 11:22 am
good backup
good resume
you only need one
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply