无法打开数据库,恢复操作已将该数据库标记为 suspect
解决办法如下:
USE UFDATA_887_2020
GO
ALTER DATABASE UFDATA_887_2020 SET EMERGENCY;
GO
ALTER DATABASE UFDATA_887_2020 SET SINGLE_USER;
GO
DBCC CHECKDB (UFDATA_887_2020, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;
GO
ALTER DATABASE UFDATA_887_2020 SET MULTI_USER;
GO
ALTER DATABASE UFDATA_887_2020 SET ONLINE;
GO