Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Analysis Services Expand / Collapse
Posted Tuesday, March 16, 2010 8:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44, Visits: 245

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!!!
Post #883815
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse