View Single Post
  #2 (permalink)  
Old January 21st, 2013, 03:50 PM
lcsgeek lcsgeek is offline
Authorized User
Points: 447, Level: 7
Points: 447, Level: 7 Points: 447, Level: 7 Points: 447, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Adrian, MI, USA.
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Getting this error message when trying to restore to Analysis Server.


TITLE: Microsoft SQL Server Management Studio
------------------------------
Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. The installed server edition allows not more than 3 partitions and not more than 1 writeback partition.
Errors in the metadata manager. An error occurred when loading the Internet Sales measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\Adventure Works DW Multidimensional_WroxSSRS2012.1.db\Adventure Works.0.cub\Fact Internet Sales 1.2.det.xml'.
Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\Adventure Works DW Multidimensional_WroxSSRS2012.1.db\Adventure Works.2.cub.xml'.
Errors in the metadata manager. An error occurred when loading the Customer Clusters ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\Adventure Works DW Multidimensional_WroxSSRS2012.1.db\Customer Clusters ~MC.1.cub.xml'.
(Microsoft.AnalysisServices)
------------------------------
BUTTONS:
OK
------------------------------
My server is local on my laptop running these versions:

Product Microsoft SQL Server Standard (64-bit)
Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Analysis Services Client Tools 11.0.2218.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 4.0.30319.296
Operating System 6.1.7601