Before anyone asks, no there aren't any recent backups I can use to fix the current situation. Yes, I do have backups but they are older than I require. Yes, we now have lots of backups since the incident occurred. Yes, I took a full backup before I started fiddling with anything.
Somehow one of our clients managed to delete half of the navigation nodes in their website tree including Trash, Files, and Files under the Root node. I still don't know how they did it, and all they can offer was that their "internet connection was slow and they just kept clicking stuff" until it broke. At first I thought this was limited to the dmNavigation table, but after attempting to Rebuild Tree Metadata unsuccessfully I was forced to copy rows from another copy of the DB (nested_tree_objects table if I recall correctly). The site is back up and all the folders are back in place, but somehow some of the pages have reverted to earlier versions (I suspect the ones that match the older DB copy). I am unable to locate any other versions of the pages in the DB (using keyword searches on the content etc), so I dont really know whether they were deleted when the parent nodes got trashed. So I guess i'm trying to get ideas as to how to get the information back... the SQL 2005 DB is set to full recovery mode, but my attempts at viewing the log file haven't been very successful. I have never had to do it before so maybe I'm just not doing it right. I have tried using ApexSQL Log viewer, but it doesnt return any operations at all (or at least it only returns those made after the backup) The one thing I am not sure about is that I have restored the DB to my local machine and i'm running the queries / programs on that DB log. Perhaps this is where the fault lies as "dbcc log(mydb)" seem to give different results between the live db and my own copy. Does anyone know if I should be restoring the DB in a different way? Any other suggestions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
