Observed error message,
An error occurred while data was being written to the query log. Although the table was created, query logging has stopped. Check the query log database or permissions for issues: OlapQueryLog
All backups are running well, can yoy uplease advise what is meaning of this error,why this error occured and what is resolution for the same.
The OlapQueryLog is a table used by the Usage-based Optimizer in Analysis Services (SSAS).
Are you using the Usage-based Optimizer feature - if not, you could turn this off?
Check with whoever has setup/configured the SSAS instance.
Maybe look at this : [Configuring the Analysis Services Query Log (MSDN)]: http://technet.microsoft.com/en-gb/library/cc917676.aspx
answered Aug 26, 2011 at 02:11 AM
Kev Riley ♦♦