Our MS SQL database crashed. Now the service is crashing immediately after start-up. The following in the error log file:
Starting up database 'msdb'.
Starting up database 'mssqlsystemresource'.
The resource database build version is 12.00.6024. This is an informational message only. No user action is required.
The database 'msdb' is marked RESTORING and is in a state that does not allow recovery to be run.
Starting up database 'model'.
The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.
Error: 927, Severity: 14, State: 2.
Database 'model' cannot be opened. It is in the middle of a restore.
SQL Server shutdown has been initiated
Please assist on steps how to start the system, we cannot access the database in "Management Studio", the MS SQL service crash immediately after start-up in Windows services, and in "Configuration Manager".
I cannot view SAP Note/KBA 2137130, as it is being updated.
We have a full database backup from last night, and hourly log backups. Hopefully this will not be required, as the last log backup ocurred around 30 min. from the crash.