如何修复 SQL Server 数据库中的恢复挂起状态?
执行以下一组查询:
ALTER DATABASE [DBName] SET EMERGENCY;
GO
ALTER DATABASE [DBName] set single_user
GO
DBCC CHECKDB ([DBName], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;
GO
ALTER DATABASE [DBName] set multi_user
GO
欲了解更多信息:https://www.stellarinfo.com/blog/fix-sql-database-recovery-pending-state-issue/ https://www.stellarinfo.com/blog/fix-sql-database-recovery-pending-state-issue/
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)