Archiving and Restoring Databases Between Versions of Analysis Services
On an Analysis server (the server that ships with Microsoft SQL Server 2000 Analysis Services), you can restore databases that were archived using an OLAP server (the server that ships with SQL Server 7.0 OLAP Services) or an Analysis server. The following table shows all the restoration paths supported for databases archived while in SQL Server 7.0 OLAP Services or SQL Server 2000 Analysis Services using native or SQL Server 2000 Meta Data Services formats with SQL Server or the Microsoft Jet 3.5 or 4.0 OLE DB provider.
| To native | To MDS | ||||||
|---|---|---|---|---|---|---|---|
| Jet 3.5/4.0 | SQL Server | SQL Server | |||||
| 7.0 | 2000 | 7.0 | 2000 | 2000 | |||
| From native(1) | Jet 3.5/4.0 | 7.0 | Yes | Yes | Yes | Yes | Yes |
| 2000 | No(3) | Yes | No(3) | Yes | Yes | ||
| SQL Server | 7.0 | Yes | Yes | Yes | Yes | Yes | |
| 2000 | No(3) | Yes | No(3) | Yes | Yes | ||
| From MDS(2) | SQL Server | 2000 | No(3) | Yes | No(3) | Yes | Yes |
1 From specifies the repository format, database engine, and version of OLAP Services or Analysis Services that archives a database; To specifies the repository format, database engine, and version of OLAP Services or Analysis Services that restores a database.
2 MDS represents the Meta Data Services (previously named Microsoft Repository) format supported by SQL Server 2000.
3 OLAP servers do not support restoration of Analysis Services databases.