On Mon, 7 Mar 2005 15:09:02 -0500, Qasim Rasheed <[EMAIL PROTECTED]> wrote: > Hi > > Does anyone has recommendation for resources where I can find > information about recovering data from SQL Server 2000 if it has been > deleted accindently. Assume that I do not have a backup. I am > specifically looking if it could be done from transaction log files.
The transaction logs are useless without a backup file. You typically restore a backup file and then apply all the intervening transaction logs since the backup was made to restore your database. That said, you could consider getting Lumigent's log explorer, which can read and selectively apply transaction logs to a database. But that would be more of a "how much data did I lose" solution than a "let's restore the db" solution. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197836 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
