How to Detach SSAS Database in SQL Server


Nov 14, 2012

Introduction

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.

Important Note:- To Attach an Analysis Services Database refer the following article "How to Attach SSAS Database in SQL Server"

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.

How to Detach Analysis Services Database in SQL Server or How to Detach SSAS Database in SQL Server

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.

Detach SSAS Database Using SSMS

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

<Detach xmlns=https://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.

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article


Geeks who read this article also read…



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."