So yesterday evening (15 minutes before I was supposed to go home for the night... of course) our web page's DB decided to spontaniously crap itself. I started getting errors which a Google search revealed some tables in the DB had gone completely missing- which looking at the DB they sure enough were gone. The accepted solution was to recover from your backup and go from there.
So I fired up MSSQL, loaded a backup, and everything did come back just fine. Except now the page hierarchy is completely scrabled.
What I mean is our nice list of parent and child pages from the first example has reordered itself to look like the second example:
Title 1 Title 1
.Main 1 Title 2
..Sub 1 .Main 1
...Pg 1 .Main 2
Title 2 ..Sub 1
.Main 2 ..Sub 2
..Sub 2 ...Pg 1
No content appears to be lost, but any menu modules built around displaying lists of pages 'under' certian headers is of course borked. Of course, that also tends to make organizing and finding anything out of hundreds of freakin' entries impossible. Trying to find a page in a big ol' list of . ... ...'s was already a PITA. Now they're just all jumbled together.
I'm trying different recovery options on the database now, but if anyone has seen anything like this happen before or has any advice, I'd really like to hear it. Thinking about sorting all these manually makes me want to start drinking professionally. 