Tengo una base de datos en suspect y me está arrojando este resultado al
ejecutar este script
exec sp_resetstatus ABC
go
RESTORE DATABASE ABC WITH RECOVERY
go
exec sp_dboption 'ABC', 'single user', true
go
DBCC CHECKDB ('ABC', REPAIR_ALLOW_DATA_LOSS)
go
exec sp_dboption 'ABC', 'single user', false
go
Resultado
Prior to updating sysdatabases entry for database 'ABC', mode = 0 and status
= 4194572 (status suspect_bit = 256).
For row in sysdatabases for database 'ABC', the status bit 256 was forced
off and mode was forced to 0.
Warning: You must recover this database prior to access.
Backup or restore operation successfully processed 0 pages in 0.000 seconds
(0.000 MB/sec).
Server: Msg 3624, Level 20, State 1, Procedure sp_dboption, Line 493
Location: recovery.c:2693
Expression: seenCkptEnd
SPID: 7
Process ID: 660
[Microsoft][ODBC SQL Server Driver]Communication link failure
[Microsoft][ODBC SQL Server Driver]Communication link failure
Connection Broken
Leer las respuestas