dbcc

Problem: The disk with transaction log crashed. Database have status suspect.- Database cannot be opened because some of the files could not be activated

Problem: The disk with transaction log crashed. Database have status suspect. Detach was succeed, but attach_single_file_db is not. i.e. attempt for attaching Database (without log) return this error:

Server: Msg 945, Level 14, State 2, Line 1
Database 'test1' cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'test1'. CREATE DATABASE is aborted.

Creating new database and substitution of garbled file is not useful.

Solution:

Скачать и читать Problem: The disk with transaction log crashed. Database have status suspect.- Database cannot be opened because some of the files could not be activated