It's important to keep Service Pack version in mind in your backup/restore strategies and operations for system databases like MSDB.

System databases can only be restored to a SQL Server version identical to the one used to create the backup. This condition goes down to the Service Pack level. A system database backup made with SQL Server SP1 cannot be restored on SQL Server SP2. If you are in a situation where you need to restore from a backup created with a different SP, you will need to do a fresh install & restore the backup before upgrading to the latest build.

This post is about accessing SSAS using Visio 2010.  For a great article on SSAS & Visio 2007, check out Dinesh Asanka's article here.

Some of the menu options are different between Visio 2010 and it's predecessor Visio 2007.  In Visio 2007 there was a Pivot Diagram option in the Data menu that would allow you to use Analysis Services as the data source.  As far as I can tell, Pivot Diagram has been removed from the Data menu in Visio 2010.  Of course you can still use the Pivot Diagram feature in Visio 2010, but it involves using the Shapes menu. 

Just create a Visio document and open the shapes menu. 

Then using the shapes menu browse to: More Shapes -> Business -> Pivot Diagram -> Pivot Diagram Shapes.

In the Pivot Diagram Shapes menu, there is a shape called "Pivot Node".

After dragging the Pivot Node shape on to the sheet, you will be presented with the Data Selector wizard, which allows you to select Analysis Services as an option.

Complete the wizard and connect to SSAS, just like you would in Visio 2007. 

From this point on, everything you know about working with Pivot Diagrams from Visio 2007 carries over to Visio 2010.

Enjoy!