Report Portal

How do I move Analysis Services 2005/2008 databases to a different folder

Q: How do I move all Analysis Services databases to a different folder?

A: Steps for moving Analysis Services databases to a different folder on the same server:

  • Start Microsoft SQL Server Management Studio, Connect to Analysis Services Server
  • Right mouse click on server name, then choose properties. Change property "DataDir" to contain new location
  • Stop Analysis Services Service
  • Move data to location specified in previous step
  • Start Analysis Services.

Read about related possible bug here.

Note: these steps will move all databases on one instance to a different folder.

Analysis Services 2008 gives you an option to detach databases, move them to different folder and then attach them to a server from there. To detach DB:  in SQL Server Management Studio select database and then right mouse click and choose option "Detach DB".  To attach DB: in SQL Server Management Studio select folder "Databases", then right mouse click and choose option "Attach DB".

Tags: faq, management

 

2007-2015 VidasSoft Systems Inc.