MS SQL server 2014 - service not starting up

[wlourens2]

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,

[jaime_rodriguez_jr · Accepted solution]

Hello Willem,

Have you tried to install the SQL server instance on a different server to restore your sap system database.

Forget the old server an install a new one in Wich you install the db engine and the db instance and finally restore your sap system database.

For me this would be the fastest way to have your system up and running instead of looking for the solution for the issue.

[wlourens2]

Hi,

Response from SAP incident on database error 824, is that we have to restore the database from backup. Any work done after the last log backup will unfortunately be lost.

Kind Regards,

[wlourens2]

Hi,

Message when trying to attach the database:

[wlourens2]

Hi Jaime,

I see SAP is not connecting (R3trans -d also failing), as the SAP tenant database is no longer exists after the restore commands.

The SAP datase is no longer visible as a database.

We can restore the database from backup, but the business will loose 30 min of work, hoping we can add the database which should still be on OS level?

Kind Regards,

[jaime_rodriguez_jr]

Hello Willem,

Good news.

From the command line with <SID>ADM What is the result of R3trans-d?

Make sure that the credentials remain the same and you are able to log in for both at operating system and SQL for the users SAPService<SID> and <SID>adm.

[wlourens2]

Hi Jaime,

Thanks for your response.

We had some success, database restored as per below.

Now database is up and running, can connect with management studio.

Unfortunately SAP is not connecting to the database, following error in the MS SQL log:

Login failed for user 'hostname\SAPServiceSID'. Reason: Failed to open the explicitly specified database 'DB1'. [CLIENT: <local machine>]

Error: 18456, Severity: 14, State: 38.

Kind Regards