admin管理员组

文章数量:1794759

SqlServer数据库Recovery Pending

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;

本文标签: 数据库sqlserverPendingrecovery