SQL Server Suspect Database Repair

USE Master

EXEC sp_resetstatus [DBNAME];

ALTER DATABASE [DBNAME] SET EMERGENCY

DBCC checkdb([DBNAME])

ALTER DATABASE [DBNAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([DBNAME], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [DBNAME] SET MULTI_USER