打开要访问的数据库,发现不能访问,状态为恢复挂起,
执行下面脚本来修复状态.
USE master
GO
--WHQJAccountsDB
ALTER DATABASE WHQJAccountsDB SET SINGLE_USER
GO
ALTER DATABASE WHQJAccountsDB SET EMERGENCY
GO
DBCC CHECKDB(WHQJAccountsDB,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE WHQJAccountsDB SET ONLINE
GO
ALTER DATABASE WHQJAccountsDB SET MULTI_USER
GO
--WHQJAgentDB
ALTER DATABASE WHQJAgentDB SET SINGLE_USER
GO
ALTER DATABASE WHQJAgentDB SET EMERGENCY
GO
DBCC CHECKDB(WHQJAgentDB,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE WHQJAgentDB SET ONLINE
GO
ALTER DATABASE WHQJAgentDB SET MULTI_USER
GO
--WHQJGameMatchDB
ALTER DATABASE WHQJGa