Upgrading from SQL Server 7.0 OLAP Services

Upgrading from SQL Server 7.0 OLAP Services

SQL Server 2000

To upgrade from Microsoft® SQL Server™ 7.0 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, 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 SQL Server 7.0 OLAP Services to C:\Program Files\Microsoft Analysis Services in SQL Server 2000 Analysis Services.

Show:
© 2016 Microsoft