Skip to Content
0
Apr 21 at 05:00 PM

MS SQL server 2014 - service not starting up

245 Views

Dear all,

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.

Kind Regards,