February 18, 2004 at 11:37 am
Hi all, this is going to sound crazy, but does anybody know how to recover tables that have been deleted from a database? And no, I don't have a backup of the database, and I've been kicking myself since this problem occured.
Any feedback would be greatly appreciated.
February 18, 2004 at 11:39 am
Do you have (not simple) logging ?
maybe log-explorer (lumigent) or log-pi can help out ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 18, 2004 at 11:41 am
Log Explorer from Lumigent.
February 18, 2004 at 11:54 am
thanks, but doesn' Log Explorer need to be installed before the deletion occured. I'm douwnloading the demo right now
February 18, 2004 at 12:09 pm
alzdba, I have full recovery model. can I somehow get those transactions back?
thanks
February 19, 2004 at 12:28 am
If only you had that (old) backup. With full logging, all could be restored to the point where you dropped the object(s).
(then you could restore to an alternate db with norecovery and then restore log to that alternate db to point in time x)
check http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=100491 for tools that can do things with the log.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply