You can restore a Microsoft® SQL Server™ 2000 Analysis Services database by using Analysis Manager or the msmdarch command.
To restore an Analysis Services database with the Analysis Manager, use the Open Archive File, Restore Database, and Restore Database Progress dialog boxes. If you are restoring a database on a remote server, you must also use the Remote Server Data Directory dialog box.
To restore an Analysis Services database using Analysis Manager
To restore an Analysis Services database with the msmdarch command, you can use the command prompt.
To restore an Analysis Services database using the msmdarch command
You can also execute the msmdarch command from a .bat file. If you want to schedule execution of a .bat file, it is recommended that you use Data Transformation Services (DTS) to create an Execute Process task that runs the batch file. The msmdarch command returns an exit code of 1 if it fails.