I’ve blogged about this before, but I managed to loose the document from my server. I’ve had lots of emails requesting the document. So I’ll try to keep this short and sweet.
I encountered a problem when restoring a SharePoint 2003 portal to a newly built server.
All three SharePoint databases were stored on a SQL cluster and we relied upon backups of the SQL server for disaster recovery.
A failure on the SharePoint server required us to re-build another server and restore the SharePoint portal. We’d done this a number of times before with no problems, but on this occasion, we received the error “Unable to find entry for Portal Site” when restoring.
As this was a newly built server we instantly thought there was corruption in the SQL Databases. We restored them from a backup before the failure occurred with no success. We then moved backward to a weekly backup from five days before the failure, still with no success. We had earlier backups but didn’t roll back further because the data in them would be too far out of date for a useful recovery.
With no obvious solutions found on the Internet we turned to Microsoft. They spent some time with us looking at the problem and came up with a document instructing us how to correctly populate a single field to allow the restore to proceed.
I know this information is for a product that is fairly out of date, but SharePoint 2003 is still has a large user base.