SQL Server Analysis services terminates unexpectedly. This happens frequently at the same time. From the event viewer, I can see the below error "The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: The following error occurred during a file operation: The process cannot access the file because it is being used by another process. . (\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\.............).."
The only reason I can see is that tape backup was running whenever it fails... The tape backup cannot backup the files related to analysis services because analysis services in up and running...
Is there by any chance, analysis services may stop due to tape backup?
Any help is highly appreciated.. Thanks!!!