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