• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Maintaining Data Reporting a... > Maintaining SQL Server 2000 Analysis...

Maintaining SQL Server 2000 Analysis Services Systems

Microsoft SQL Server 2000 Analysis Services allows you to ensure data integrity by archiving and restoring OLAP cubes. Another key Analysis Services data integrity task you should perform is to process the OLAP cubes associated with a database whenever you update that database’s data or structure so that the cubes reflect the changes.

Archiving and Restoring OLAP Cubes

To archive an Analysis Services database, right-click a database icon in the Analysis Manager window and then click Archive Database. Provide the archive settings in the Archive Database dialog box, and then click Archive to archive the database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint