Upgrading from an Earlier Version

Analysis Services

Analysis Services

Upgrading from an Earlier Version

To upgrade from an earlier version of Microsoft® SQL Server™ 2000 Analysis Services (previously OLAP Services), perform the following actions:

  • Back up the Analysis Services repository and query log.

  • Before you install Analysis Services, as a precaution against data loss, back up the Analysis Services repository (Msmdrep.mdb), which contains Analysis Services meta data, and the query log (Msmdqlog.mdb). These files are located in the Bin folder in the Analysis Services folder.Run Setup.

    Install Analysis Services by running the Analysis Services Setup program. For more information, see Running Setup.

When you upgrade from an earlier version, Setup does not delete or replace the Analysis Services repository or the query log.

Note  The default location for Analysis Services has changed from C:\Program Files\OLAP Services in earlier versions of Analysis Services to C:\Program Files\Microsoft Analysis Services in this version of Analysis Services.