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)…

blog_20161209_1

…and run the following:

<DBCC xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine>

<Object>

<DatabaseID>Work Metrics</DatabaseID>

<CubeID>Hourly Insights</CubeID>

</Object>

</DBCC>

The output looks like this:

blog_20161209_2

As usual more info can be found from MSDN: https://msdn.microsoft.com/en-us/library/mt156975.aspx

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

Follow

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.

>