SELECT GETDATE() as runtime, command,
      session_id, database_id, total_elapsed_time,
      percent_complete, estimated_completion_time, 
      wait_resource, wait_time, wait_type, blocking_session_id,
      reads, writes, cpu_time
      FROM sys.dm_exec_requests
      WHERE command = 'DB STARTUP'
      and database_id=17

alter database [YOURDB] set emergency 
go
select databasepropertyex('YOURDB','Status') [CurrentStatus]
go
dbcc  checkdb('YOURDB')
go

07/27/2018 14:50:24,spid9s,Unknown,Recovery is complete. This is an informational message only. No user action is required.
07/27/2018 14:50:24,spid9s,Unknown,An error occurred during recovery<c/> preventing the database 'Ax09_Work' (database ID 17) from restarting. Diagnose the recovery errors and fix them<c/> or restore from a known good backup. If errors are not corrected or expected<c/> contact Technical Support.
07/27/2018 14:50:24,spid9s,Unknown,Error: 3414<c/> Severity: 21<c/> State: 2.
07/27/2018 14:50:23,spid28s,Unknown,Database 'Ax09_Work' is already open and can only have one user at a time.
07/27/2018 14:50:23,spid28s,Unknown,Error: 924<c/> Severity: 14<c/> State: 1.
07/27/2018 14:50:21,spid9s,Unknown,The operating system returned error 19(failed to retrieve text for this error. Reason: 15105) to SQL Server during a write at offset 0x000037d91f0000 in file 'K:\DatabaseData\Ax09_Work2.ndf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.
07/27/2018 14:50:21,spid9s,Unknown,Error: 823<c/> Severity: 24<c/> State: 3.
07/27/2018 14:15:12,spid9s,Unknown,Recovery is writing a checkpoint in database 'Ax09_Work' (17). This is an informational message only. No user action is required.

ALTER DATABASE [ax09_work] SET ONLINE;
GO

select * from sys.master_files where database_id=17

database_id file_id     file_guid                            type type_desc                                                    data_space_id name                                                                                                                             physical_name                                                                                                                                                                                                                                                    state state_desc                                                   size        max_size    growth      is_media_read_only is_read_only is_sparse is_percent_growth is_name_reserved create_lsn                              drop_lsn                                read_only_lsn                           read_write_lsn                          differential_base_lsn                   differential_base_guid               differential_base_time  redo_start_lsn                          redo_start_fork_guid                 redo_target_lsn                         redo_target_fork_guid                backup_lsn
----------- ----------- ------------------------------------ ---- ------------------------------------------------------------ ------------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----- ------------------------------------------------------------ ----------- ----------- ----------- ------------------ ------------ --------- ----------------- ---------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ------------------------------------ ----------------------- --------------------------------------- ------------------------------------ --------------------------------------- ------------------------------------ ---------------------------------------
17          1           53C67F77-0F90-4666-A893-11FB9B0955A7 0    ROWS                                                         1             Ax09_Work                                                                                                                        K:\DatabaseData\Ax09_Work.mdf                                                                                                                                                                                                                                    0     ONLINE                                                       52925912    -1          0           0                  0            0         0                 0                NULL                                    NULL                                    NULL                                    NULL                                    7516563000002413000309                  6A2374E5-9BF1-4B2D-821A-68BB3718BFB0 2018-07-23 18:06:09.030 NULL                                    NULL                                 NULL                                    NULL                                 NULL
17          2           F6B00A0D-F64B-48F2-BE2B-36D5F577955B 1    LOG                                                          0             Ax09_Work_log                                                                                                                    E:\DataBaseLog\Ax09_Work.LDF                                                                                                                                                                                                                                     0     ONLINE                                                       23296072    32000000    12800       0                  0            0         0                 0                NULL                                    NULL                                    NULL                                    NULL                                    NULL                                    NULL                                 NULL                    NULL                                    NULL                                 NULL                                    NULL                                 NULL
17          3           301EA4CE-AB61-4303-914B-738A9D1B475A 1    LOG                                                          0             Ax09_Work_log4                                                                                                                   I:\DataBaseLog\Ax09_Work_log4.ldf                                                                                                                                                                                                                                0     ONLINE                                                       28883152    268435456   12800       0                  0            0         0                 0                3798381000001298400002                  NULL                                    NULL                                    NULL                                    NULL                                    NULL                                 NULL                    NULL                                    NULL                                 NULL                                    NULL                                 NULL
17          4           38FD76C1-696A-466E-836C-D4A4B3666DB8 1    LOG                                                          0             Ax09_Work_log3                                                                                                                   G:\DataBaseLog\Ax09_Work_log3.ldf                                                                                                                                                                                                                                0     ONLINE                                                       23386496    51200000    12800       0                  0            0         0                 0                477747000000067600008                   NULL                                    NULL                                    NULL                                    NULL                                    NULL                                 NULL                    NULL                                    NULL                                 NULL                                    NULL                                 NULL
17          5           6201D128-A15D-4F62-82C7-65DA1EFD5A6A 0    ROWS                                                         2             Ax09_Work3                                                                                                                       K:\DatabaseData\Ax09_Work3.ndf                                                                                                                                                                                                                                   0     ONLINE                                                       8742904     -1          12800       0                  0            0         0                 0                1326515000000055300001                  NULL                                    NULL                                    NULL                                    7516563000002413000309                  6A2374E5-9BF1-4B2D-821A-68BB3718BFB0 2018-07-23 18:06:09.030 NULL                                    NULL                                 NULL                                    NULL                                 NULL
17          6           DEB930E0-EA36-44A2-B1F4-7BBA994BA2DD 0    ROWS                                                         1             Ax09_Work2                                                                                                                       K:\DatabaseData\Ax09_Work2.ndf                                                                                                                                                                                                                                   0     ONLINE                                                       29439096    -1          12800       0                  0            0         0                 0                1602627000002536200001                  NULL                                    NULL                                    NULL                                    7516563000002413000309                  6A2374E5-9BF1-4B2D-821A-68BB3718BFB0 2018-07-23 18:06:09.030 NULL                                    NULL                                 NULL                                    NULL                                 NULL

(6 row(s) affected)

2018-07-19 01:28:53.63 spid15s     The operating system returned error 19(failed to retrieve text for this error. Reason: 15105) to SQL Server during a write at offset 0x000036e2d2a000 in file 'K:\DatabaseData\Ax09_Work2.ndf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.