EXEC sp_resetstatus ‘JRERP-dzfp‘
ALTER DATABASE [JRERP-DZFP] SET EMERGENCY;
DBCC checkdb([JRERP-DZFP]);
ALTER DATABASE [JRERP-DZFP] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CheckDB ([JRERP-DZFP], REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [JRERP-DZFP] SET MULTI_USER;
原文：https://www.cnblogs.com/hesijian/p/12468268.html