SSAS更改備份目的及還來源路徑

到SSAS安裝路徑下,找到C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config\msmdsrv.ini
開啟後,修改<AllowedBrowsingFolders>C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup\|C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\</AllowedBrowsingFolders>
這行加入要備份還原的目錄,例d:\ASDB\Backup\
修改後如下
<AllowedBrowsingFolders>E:\ASDB\backup|C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup\|C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\</AllowedBrowsingFolders>  
備份或還源時就可選擇到你要的路徑了