FORCE DATABASE OFFLINE

Recently I get into a situation where one of Database file freeze and stopped responding to any of the queries executed on the objects using the file On killing the select statement it goes into rollback state with WAIT TYPE DISKIO_SUSPEND. DISKIO_SUSPEND: Occurs when a task is waiting to access a file when an external backup is active. […]