July 15, 2014 at 5:02 am
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
July 16, 2014 at 11:22 am
Have you checked the Windows evnet logs ? Specifically the System and Application ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 16, 2014 at 9:01 pm
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
July 17, 2014 at 2:39 am
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)
July 17, 2014 at 3:21 am
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....
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply