Consistency Check an Analysis Services Database

By Lori Brown | Analysis Services

Dec 09

— 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=”>


<DatabaseID>Work Metrics</DatabaseID>

<CubeID>Hourly Insights</CubeID>



The output looks like this:


As usual more info can be found from MSDN:

For more information about blog posts, concepts and definitions, further explanations, or questions you may have…please contact us at We will be happy to help! Leave a comment and feel free to track back to us. Visit us at!


About the Author

Lori is an avid runner, cross fitter and SQL enthusiast. She has been working for SQLRX for 15 years and has been working with SQL in general for 25 years. Yup...she is an old hand at this stuff.