Backup Strategies with SQL Server 2005 Analysis Services | Backup Strategies with SQL Server 2005 Analysis Services |
| Written by Edward Melomed | |
| Tuesday, 01 May 2007 00:00 | |
|
This white paper briefly discusses several issues related to executing the Analysis Services Backup command. You will learn how to choose the correct backup strategy, learn various options provided in the Backup command, and see an example of how to automate Analysis Services backup. Overview Backup and restore operations are an integral part of the Analysis Services infrastructure. In Microsoft® SQL Server™ 2005 Analysis Services, the backup operation has been completely rebuilt. Backup and restore are done by issuing XML for Analysis commands against Analysis Services. After receiving a Backup command, Analysis Services determines which files need to be packages in the single backup file. It will take care of the consistency of the database at the time of the backup and restore. It will make sure that all the objects in the backup file are of the same version. It is also important to mention the granularity of backup and restore. You back up the entire Analysis Services database into a single file and restore the entire database as well. |
Top Rated
- MS Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
- Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
- MS Paper: 2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
- Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows XP
- Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Com
- Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
- Functionality & Performance Testing Analysis Services 2005 with Teradata v12
- Analysis Services Distinct Count Optimization
