I haven't personally had the need to restore from logs either, but at least you have them. There are SQL experts (companies) you can call for assistance that do nothing but high-end MSSQL stuff. The only one I've worked with is Edgewoodsolutions.com. I don't know what their pricing is, but it can at least give you a starting point if you plan to shop around. Good luck.
Regards, -- Jeff Coughlin On Jun 20, 2008, at 4:44, schlub wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
