При сбое питания накрылась база. Sp_attach_db и sp_attach_single_db не помогают. Что делать ???
Вот ответы на мои действия:
1)
EXEC sp_attach_single_file_db @dbname = 'ASD',
@physname = 'D:\SQLData\FC_BTest.mdf'
Server: Msg 945, Level 14, State 2, Line 1
Database 'ASD' 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 'ASD'. CREATE DATABASE is aborted.
2)
EXEC sp_attach_db @dbname = 'ASD',
@filename1 = 'D:\SQLData\FC_BTest.mdf',
@filename2 = 'D:\SQLData\FC_BTest_log.ldf'
Server: Msg 8941, Level 22, State 102, Line 1
Table Corrupt: Object ID 6647, index ID 1, page (3:153819660). Test (offset + len < PAGESIZE) failed. Slot 0, offset 0x3620 is invalid.
34 transactions rolled forward in database 'ASD' (.

Connection Broken