SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com

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.

To Attach an Analysis Services Database refer the following article “How to Attach SSAS Database in SQL Server

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.

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

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.

Detach SSAS Database Using SSMS

Trending Analysis Services Articles and Tips

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.

Chetna Bhalla

LESS ME MORE WE

Chetna Bhalla, the founder of MyTechMantra.com, believes that by sharing knowledge and building communities, we can make this world a better place to live in. Chetna is a Graduate in Social Sciences and a Masters in Human Resources and International Business. She is an alumnus of Vignana Jyothi Institute of Management, Hyderabad, India. After graduation, Chetna founded this website, which has since then become quite a favorite in the tech world. Her vision is to make this website the favorite place for seeking information on Databases and other Information Technology areas. She believes that companies which can organize and deploy their data to frame strategies are going to have a competitive edge over others. Her interest areas include Microsoft SQL Server and overall Database Management. Apart from her work, Chetna enjoys spending time with her friends, painting, gardening, playing the violin, and spending time with her son.

Add comment

Newsletter Signup! Join 15,000+ Professionals




Be Social! Like & Follow Us

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Advertisement