How to Detach SSAS Database in SQL Server

This article explains How to Detach Analysis Services Database in SQL Server. The steps mentioned in this article are applicable on SQL Server 2008 and Higher Versions.

Different ways to Detach an Analysis Services Database

• Using SQL Server Management Studio
• Using XMLA Scripts
• Programmatically Using Analysis Management Objects (AMO)

However, in this article we will take a look at detach the analysis services database using SQL Server Management Studio and by Using XMLA Script.

Detach Analysis Services Database / Detach SSAS Database Using SQL Server Management Studio

Step 1. Connect to Analysis Services Instance Using SQL Server Management Studio

Step 2. Right click Analysis Database (SSAS) and choose Detach… from the popup to open up Detach Database Dialog box.

Step 3. In Detach Database Dialog box click OK to detach the analysis services database. If you want to generate XMLA Script to detach analysis database then click on Script and then choose “Script Action to New Query Window” as shown in the below snippet.

Trending Analysis Services Articles and Tips

• Database Consistency Checker DBCC CHECK For Analysis Services Database in SQL Server 2016 for Tabular and Multidimensional Databases
• How to Backup Analysis Services Database in SQL Server Using SQL Server Management Studio
• How to Automate Backup of Analysis Services Database Using SQL Server Agent Job
• How to Restore Analysis Services Database in SQL Server Using SQL Server Management Studio
• How to Synchronize Analysis Services Database Using Synchronize Database Wizard in SSMS
• How to Attach SSAS Database in SQL Server
• How to Detach SSAS Database in SQL Server

XMLA Script to Detach SSAS Database (Analysis Services) in SQL Server 2008 and Higher Versions 

<Detach xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
  <Object>
    <DatabaseID>MyTechMantra</DatabaseID>
  </Object>
</Detach>

Conclusion

In this article you have seen different methods in which one can attach an Analysis Services (SSAS) database in SQL Server 2008 and higher versions.