DB shutdown when backup is running.

[Former Member]

We cannot start our SAP on SQL anymore. We guess it's because

the SAP system was stopped by somebody while a backup was running.

How to start the SAP system in this situation?

Thanks!

[markus_doehr2 · Accepted solution]

As always, if systems are not coming up, check the files

dev_disp

dev_w0

Also check if your SQL server is running.

Markus

[Former Member · Accepted solution]

The SQL is NOT running. And we cannot start it. Please advise more. Thanks!

[markus_doehr2 · Accepted solution]

Check the Windows event log, check the SQL server log.

Markus

[Former Member · Accepted solution]

In both logs , we see only something like DB is down. No further info. Please advise. Thanks!

[clas_hortien · Accepted solution]

Hi,

please send us the exact message you see. Or please send us the first 50 rows of the SQL Server errorlog.

Best regards

Clas

[markus_doehr2 · Accepted solution]

Christy,

to help you we need more information like "something that DB is down".

Open SQL-Studio and check the database, start it. If that fails for some reason you will find the reason in the windows even log (application).

Markus