Rebuilding SQL2000 analysis services after server crash and attaching the Cubes

Hi,

The SQL2000 database server got crashed and has to be rebuilt from the scratch. The OS and SQL2000 Database and Analysis Services go reinstalled and luckily the data files residing on the SAN is intact and we were able to reattach the SQL databases.

The question is how can I reattach the OLAP databases and cubes. Apparently we currently do not have backups of OLAP databases but the OLAP data directory on SAN is available and is intact.

So Is it possible to reattach the OLAP database and cubes just like the way we attach the SQL databases.

Please let me know how we can fix the issue at the moment since this is a production issue.

Thanks

Vish

In Analysis Services 2000 all the informations about cubes and dimension structures are stored in the metadata repository db.

The metadata repository db, by default, is an Access db (msmdrep.mdb) that you can migrate to a SQL Server db using Analysis Manager (right click on the server and choose migrate repository).

So if you now have "that" metadata repository (the one before the crash) you can use it and AS can recognise the structure in your OLAP data directory but if you don't ... I don't know a solution to your problem.

Do you really don't have any backup of your production OLAP db?

Francesco