SqlServer数据库Recovery Pending

执行以下步骤恢复到正常状态

ALTER DATABASE DBNAME SET  SINGLE_USER WITH NO_WAIT;
ALTER DATABASE DBNAME SET EMERGENCY;
DBCC checkdb (DBNAME, REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE DBNAME SET online;
ALTER DATABASE DBNAME SET  Multi_USER WITH NO_WAIT;