How to Attach and Detach a SQL Server Analysis Services Database

preview_player
Показать описание
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here:

In this video Scott will walk you through how to move a database (server to server, instance to instance, disk to disk, and folder to folder) in analysis services. There is a new feature in SSAS 2008 that will allow you to attach and detach an Analysis Services database.

Highlights from this video:

- What is the purpose of attach and detach?
- Detach cannot have an open connection
- Different techniques to move a database
- Attach
- Backup and restore (covered in next video)
- How to detach and attach an Analysis Services database

and much more...
Рекомендации по теме
Комментарии
Автор

Thank you. Its a good piece of information. You moved only the cube or database to J:\ drive, what about the meta data files such as Cryptkey & master.vmp etc. When i cut and move the cube in my environment, i see the folder is moved but a empty folder with same name exists at source with a cryptkey file.

foodiegowda