{"id":15996,"date":"2018-01-09T18:16:15","date_gmt":"2018-01-09T10:16:15","guid":{"rendered":"http:\/\/blog.pmail.idv.tw\/?p=15996"},"modified":"2018-01-09T18:17:25","modified_gmt":"2018-01-09T10:17:25","slug":"sharepoint-2013-%e8%b3%87%e6%96%99%e5%ba%ab%e7%99%bc%e7%94%9f%e9%8c%af%e8%aa%a4-sharepoint_config-%e7%95%b0%e5%b8%b8","status":"publish","type":"post","link":"https:\/\/blog.pmail.idv.tw\/?p=15996","title":{"rendered":"SharePoint 2013\u00a0\u8cc7\u6599\u5eab\u767c\u751f\u932f\u8aa4 (Sharepoint_config \u7570\u5e38)"},"content":{"rendered":"<p>SharePoint 2013\u00a0\u8cc7\u6599\u5eab\u767c\u751f\u932f\u8aa4\uff0c\u5c0e\u81f4\u7cfb\u7d71\u7121\u6cd5\u6b63\u5e38\u904b\u4f5c<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro1.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-15997 size-full\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro1.jpg\" alt=\"\" width=\"356\" height=\"280\" srcset=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro1.jpg 356w, https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro1-300x236.jpg 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><\/p>\n<p><!--more--><\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-15998 size-full\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro.jpg\" alt=\"\" width=\"722\" height=\"154\" srcset=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro.jpg 722w, https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro-300x64.jpg 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/a><\/p>\n<p>\u56e0\u70ba\u672c\u8eab\u5c0dSQL \u4e0d\u719f\u6240\u4ee5\u627e\u4e86\u4e00\u4e0b\u8cc7\u8a0a\u6709\u770b\u5927\u4e0b\u9762\u65b9\u5f0f\u53ef\u4ee5\u89e3\u6c7a\uff0c\u4f9d\u7167\u6b64\u6b65\u9a5f\u78ba\u5be6\u53ef\u4ee5\u89e3\u6c7a\u6211\u7684\u60c5\u6cc1\u3002<\/p>\n<p>1\u3001\u4fee\u6539\u6578\u64da\u5eab\u70ba\u7dca\u6025\u6a21\u5f0f<\/p>\n<p>ALTER DATABASE Sharepoint_Config SET EMERGENCY<\/p>\n<p>2\u3001\u4f7f\u6578\u64da\u5eab\u8b8a\u70ba\u55ae\u7528\u6236\u6a21\u5f0f<\/p>\n<p>ALTER DATABASE Sharepoint_Config SET SINGLE_USER<\/p>\n<p>3\u3001\u4fee\u5fa9\u6578\u64da\u5eab\u65e5\u8a8c\u91cd\u65b0\u751f\u6210\uff0c\u6b64\u547d\u4ee4\u6aa2\u67e5\u7684\u5206\u914d\uff0c\u7d50\u69cb\uff0c\u908f\u8f2f\u5b8c\u6574\u6027\u548c\u6240\u6709\u6578\u64da\u5eab\u4e2d\u7684\u5c0d\u8c61\u932f\u8aa4\u3002\u7576\u60a8\u6307\u5b9a\u201cREPAIR_ALLOW_DATA_LOSS\u201d\u4f5c\u70baDBCC CHECKDB\u547d\u4ee4\u53c3\u6578\uff0c<br \/>\n\u8a72\u7a0b\u5e8f\u5c07\u6aa2\u67e5\u548c\u4fee\u5fa9\u5831\u544a\u7684\u932f\u8aa4\u3002\u4f46\u662f\uff0c\u9019\u4e9b\u4fee\u5fa9\u53ef\u80fd\u6703\u5c0e\u81f4\u4e00\u4e9b\u6578\u64da\u4e1f\u5931\u3002<\/p>\n<p>DBCC CheckDB (Sharepoint_Config , REPAIR_ALLOW_DATA_LOSS)<\/p>\n<p>4\u3001\u4f7f\u6578\u64da\u5eab\u8b8a\u56de\u70ba\u591a\u7528\u6236\u6a21\u5f0f<\/p>\n<p>ALTER DATABASE Sharepoint_Config SET MULTI_USER<\/p>\n<p>5.\u63a5\u8457\u5c07SQL\u670d\u52d9\u91cd\u65b0\u555f\u52d5\u5c31\u53ef\u4ee5<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro3.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16001 size-full\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro3.jpg\" alt=\"\" width=\"785\" height=\"471\" srcset=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro3.jpg 785w, https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro3-300x180.jpg 300w, https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2018\/01\/SP.jpg-db-erro3-768x461.jpg 768w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p>\u53c3\u8003\u9023\u7d50:<\/p>\n<p>https:\/\/ask.hellobi.com\/blog\/tianshansoft\/2026<\/p>\n<div class=\"21cd169d3c0f71e95b84db320302cb4a\" data-index=\"1\" style=\"float: right; margin:10px 0 10px 10px;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8711325745898650\"\r\n     crossorigin=\"anonymous\"><\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>SharePoint 2013\u00a0\u8cc7\u6599\u5eab\u767c\u751f\u932f\u8aa4\uff0c\u5c0e\u81f4\u7cfb\u7d71\u7121\u6cd5\u6b63\u5e38\u904b\u4f5c<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[25,114],"tags":[],"class_list":["post-15996","post","type-post","status-publish","format-standard","hentry","category-sharepoint2010","category-2012sql"],"_links":{"self":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/15996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15996"}],"version-history":[{"count":3,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/15996\/revisions"}],"predecessor-version":[{"id":16002,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/15996\/revisions\/16002"}],"wp:attachment":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}