Category Archives for "Analysis Services"

Dec 09

Consistency Check an Analysis Services Database

By Lori Brown | Analysis Services , SQL Administration , SQL Server , Upgrade

— By Lori Brown @SQLSupahStah I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)… …and run the following: <DBCC xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]

Continue reading
Dec 09

Consistency Check an Analysis Services Database

By Lori Brown | Analysis Services , SQL Administration , SQL Server , Upgrade

— By Lori Brown @SQLSupahStah I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)… …and run the following: <DBCC >=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]

Continue reading
>