How to Attach and Detach a SQL Server Analysis Services Database

Описание: This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here:

http://www.learnitfirst.com/Course165

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...