my database has 20 tables.
out of which 8 tables is opening but the remaining 12 shows error
no backup has been created recently. last full backup on jan 8, 2017.
i do the
DBCC CheckDB against the corrupted database.
it shows the following error
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x0; actual signature: 0x5555300). It occurred during a read of page (1:58) in database ID 10 at offset 0x00000000074000 in file 'D:\App_Data\SJ_Extended.mdf:MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe 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.
i also tried
DBCC CheckDB ('SJ_Extended', REPAIR_ALLOW_DATA_LOSS)
same error occurs
guide me to recover the datas