Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't start Analysis Services on cluster after restoring system databases Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2014 5:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, October 10, 2014 6:24 AM
Points: 81, Visits: 243
Hi all,

Last night we had a suspected network issue which caused all connections to several of our SQL servers to drop out and resulted in one cluster having a corruption of it's master database. I rebuilt and restored the master from the latest backup using SQLCMD, then also restored the latest backups of MSDB and model.

The SQL Server and SQL Agent Services are now running fine, but the SQL Analysis services are refusing to start and I'm getting no useful messages in the error log.

Can anyone think of anything else I need to do? This is on SQL 2008 R2...

Thanks,

Matt
Post #1592505
Posted Wednesday, July 16, 2014 11:22 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:01 PM
Points: 3,221, Visits: 2,374
Have you checked the Windows evnet logs ? Specifically the System and Application ?



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #1593208
Posted Wednesday, July 16, 2014 9:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 6:13 PM
Points: 24, Visits: 270
Check the OLAP log to see if there is any info. You can find the location of the log on the advanced tab of the SSAS server in SQL Config manager

SQL Server Best Practices Supporter
Post #1593362
Posted Thursday, July 17, 2014 2:39 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, October 10, 2014 6:24 AM
Points: 81, Visits: 243
I've found a couple of interesting entries in the OLAP log....

(30/09/2013 13:13:20) Message: Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry doesn't contain all necessary information, server instance name can not be retrieved correctly, failure during timer creation, etc. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC121001B)
(9/30/2013 1:13:20 PM) Message: The file '\\?\D:\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)

(10/8/2013 7:33:10 PM) Message: The file '\\?\D:\OLAP\Data\master.vmp' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)
(10/8/2013 7:33:10 PM) Message: The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. File system error: The following error occurred while opening the file '\\?\D:\OLAP\Data\master.vmp'. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210000)

Post #1593439
Posted Thursday, July 17, 2014 3:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, October 10, 2014 6:24 AM
Points: 81, Visits: 243
On further investigation I've noticed that the master.vmp file is empty - it must have been wiped or corrupted when the service cut out. Do you know if there is a way to potentially recover this situation other than to reinstall SSAS? Unfortunately I know very little about SSAS....
Post #1593447
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse