Wednesday, July 9, 2008

Cube Restore Chokes Without SQL Server 2005 SP2

I just rebuilt my development machine's SQL Server 2005 instance and forgot to re-install SP2. One of the quirky reminders to "do the right thing" and update/patch the base installation is transferring hypercubes between instances of SQL Server 2005. See the screenshot on the right for an example of what the hand slap looks like.

Veterans have experienced this minor flesh wound before.

http://weblogs.asp.net/jgalloway/archive/2007/06/21/sql-server-analysis-services-quot-errors-in-the-metadata-manager-quot-when-restoring-a-backup.aspx