September 18, 2008 at 11:27 am
I just deleted the wrong table, is there any way to get it back?
Does it go into some sort of recycle bin or something? Or is it now gone for ever?
September 18, 2008 at 11:49 am
No it didn't go to a recycle bin and there are ways to get it back. Check out the following posts from earlier today.
http://www.sqlservercentral.com/Forums/Topic572003-1291-1.aspx
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 12:03 pm
That link is to this page
September 18, 2008 at 12:17 pm
What recovery model are you using on the database, and do you have a current backup (and if approriate, transaction log backups) from prior to the accidental delete?
😎
September 18, 2008 at 12:55 pm
Time to do a point in time recovery, if you can. If not, get a log browsing tool.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 18, 2008 at 1:00 pm
OK thanks David, I found the post from earlier today
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply