–Recover from a Suspect db on SQL Server 2005 Standard Service Pack2
—Error: 3414, Severity: 21, State: 1.
–During redoing of a logged operation in database ‘MY_DB’, an error occurred at log record ID (5006:4238:75).
–Typically, the specific failure is previously logged as an error in the Windows Event Log service.
–Restore the database from a full backup, or repair the database.
–I progressed with these steps , to get the db back to an ONLINE state
–NOTE : This is a last resort , and I only tried , once I’d exhausted recovery from backup etc

ALTER DATABASE MY_DB SET ONLINE;
GO
DBCC CHECKDB (MY_DB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO
ALTER DATABASE MY_DB SET EMERGENCY;
GO
DBCC CHECKDB (MY_DB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO
ALTER DATABASE MY_DB SET SINGLE_USER;
GO
DBCC CHECKDB (MY_DB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO
ALTER DATABASE MY_DB SET MULTI_USER;
GO 
SELECT state_desc FROM sys.databases WHERE name='MY_DB';

Author: Jack Vamvas