When SharePoint barfs
A client has a SharePoint installation that has died, with all their project files and data in it.
In the course of searching for how to resurrect it, I’ve found the following that seem to be things that others may well benefit from:*An article on the Official SBS Blog, pointing to an unofficial tool:
During disaster recovery, if no backups other than the database files exist, we may manually extract the files from the database as a “belt and suspenders” approach to disaster recovery.
*A script from Mark Jen at Plaxo that restores files from SharePoint SQL DB with their directory structure
*An article from Ed Walters on how to backup SharePoint
Possibly the biggest lesson here is to ensure that if your using SharePoint, make sure you back it up PROPERLY, ALL OF IT.