How to restore an Analysis Services database using Analysis Manager

To restore a Microsoft® SQL Server™ 2000 Analysis Services database using Analysis Manager

1. In the Analysis Manager tree pane, right-click the server to which you want to restore the database, and then click Restore Database.
   
   
2. If you are restoring a database on a remote server, the Remote Server Data Directory dialog box appears. Specify the path of the Data directory to which the database will be restored. This directory will contain the files for the database after the restoration is complete. Click OK.
   
   
3. In the Open Archive File dialog box, specify the path and file name of the archive file, and then click Open.
   
   
4. In the Restore Database dialog box, click Restore.
   
   
5. In the Restore Database Progress dialog box, monitor the progress of the restoration. You can cancel the restoration after it has begun. You can also save the restore log.

See Also

Restoring an Analysis Services Database