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