All of them are achiveable in MS Analysis Services 2000 itself.

1. You can create DTS Packages for processing the cubes and schedule them through SQL Server Agent (Jobs). This can...

For cubes, you may consider taking the backup of the cube database.

DTS, can be saved as a visual basic file (*.bas) which can be edited using any text editor....