Hi Guys, i'm backing up 4 cube databases nightly and then moving the backup file and appending a timestamp to the file in order to keep a few days copy of the backup. Strange thing is that one of the backups keeps failing intermittently, i'm using
the same syntax as in the other backups, only difference is the db name and location of backup file. The database backup file when it does backup sucessfully is over 2 GB, does anyone know what could be happening. I'm running a 64 bit version
of windows and 64 bit SQL server (2005).
here is the msg i'm getting
'Executed as user: MPXCOLO\SQLAgent. ...n: Server: The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader
reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility) at Microsoft.AnalysisServices.Xmla.XmlaClient.SendMessageAndReturnResult(String&
result, Boolean skipResult) at Microsoft.AnalysisServices.Xmla.XmlaClient.Execute(String command, String properties, String& result
View Complete Post