Browse by Tags

• analysis
• Analysis Services
• cube
• databases
• dimension
• error
• execute
• high availability
• holap
• molap
• olap
• operation failed
• reporting
• restore
• rolap
• security
• sql server
• sqlagent
• storage mode
• xmla

Backup and Restore of Analysis Services Database - gotchas
12 December 07 02:38 AM | SQL Master | 2 Comments   

Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure. Read More...

Filed under: sql server, olap, dimension, high availability, cube, backup, storage mode, restore, rolap, molap, holap

Automation of Analysis Services database backup
26 September 07 03:19 AM | SQL Master | 2 Comments   

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple, Read More...

Filed under: sql server, databases, reporting, Analysis Services, backup, security, sqlagent, xmla

The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
28 August 07 02:08 AM | SQL Master | 2 Comments   

Full error text of above message while performing the backup of a Cube: The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader Read More...

Filed under: sql server, analysis, cube, execute, operation failed, error, backup