What an adventure this job has been!
I am still in Calgary. :)
The messes we have uncovered have caused no end of struggle to make things work in our migrating this client to SBS 2008.
The biggest issue we are working on right now is an unstable Companyweb SharePoint v2 database (SQL 2005 integrated on SBS 2003 R2 Premium) that refuses to keep its connection with SharePoint. There is 80GB, yes Gigabytes, of data in this site and we need to somehow get all of it!
The proper way:
- SmallBizServer.net: SBS 2003 R2 - Upgrading the Sharepoint MSDE instance to SQL 2005
We have managed to use BeyondCompare V3 to save us from having to figure out which files we have managed to copy over to one of the local workstations.
Our two remaining options are SharePoint Database Explorer or bringing the 80GB worth of databases up with us on a ShadowProtect image and try and attach those databases to a fresh and stable install of SharePoint V2.
Never a dull moment. :D
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book