Home > Database > Mysql Tutorial > body text

解决SQL Server [Suspect]

WBOY
Release: 2016-06-07 17:45:14
Original
1172 people have browsed it

昨天因断电,数据库 "DatabaseName" 被标记为 [Suspect],被质疑了? Search 后,以下方案 最终 解决了问题。 DataBaseName SET EMERGENCY; DataBaseName SET SINGLE_USER; GO DBCC CHECKDB (DataBaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_E

昨天因断电,数据库 "DatabaseName" 被标记为 [Suspect],香港服务器,美国服务器,被质疑了?

Search 后,美国空间,以下方案最终解决了问题。

DataBaseName SET EMERGENCY; DataBaseName SET SINGLE_USER; GO DBCC CHECKDB (DataBaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS; DataBaseName SET MULTI_USER; DataBaseName SET ONLINE; GO

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!