SqlServer数据库Recovery Pending

xiaoxiao2021-02-27  144

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

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;

转载请注明原文地址: https://www.6miu.com/read-13523.html

最新回复(0)