Detach SSAS Database in SQL Server

In this article we will take a quick look at How to Detach Analysis Services Database. The steps mentioned in this article are applicable on SQL Server 2008 and Higher Versions.

Some of the different ways in which an analysis services database can be moved are mentioned below.

• 
  
• 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 or Detach SSAS Database Using SQL Server Management Studio

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

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

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.

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.