{"id":1048,"date":"2018-09-03T16:29:13","date_gmt":"2018-09-03T14:29:13","guid":{"rendered":"http:\/\/dety.net.ua\/?p=1048"},"modified":"2018-09-03T16:29:13","modified_gmt":"2018-09-03T14:29:13","slug":"fix-all-failed-exchange-database-content-indexes","status":"publish","type":"post","link":"https:\/\/dety.net.ua\/?p=1048","title":{"rendered":"Fix All Failed Exchange Database Content Indexes"},"content":{"rendered":"<p>Source:<a href=\"https:\/\/practical365.com\/exchange-server\/fix-all-failed-exchange-database-content-indexes\/\">https:\/\/practical365.com\/exchange-server\/fix-all-failed-exchange-database-content-indexes\/<\/a><\/p>\n<p>One of the issues that my <a href=\"https:\/\/practical365.com\/get-daghealth-ps1-database-availability-group-health-check-script\">Get-DAGHealth.ps1<\/a> script alerts for is failed content indexes on database copies in a database availability group.<\/p>\n<p><em>Note: for failed content indexes on servers that are not DAG members refer to <a href=\"https:\/\/practical365.com\/fix-failed-database-content-index-exchange-2013\/\">this article<\/a> instead.<\/em><\/p>\n<p>Failed content indexes can easily go unnoticed when everything else is working fine however they will eventually begin to cause problems for you, for example by <a href=\"https:\/\/practical365.com\/cannot-activate-database-copy-content-index-catalog-files-in-failed-state\">preventing database switchovers<\/a>.<\/p>\n<p>Fixing a single failed content index is easy, but if there are multiple failed indexes you can speed things up a little by fixing them all with a single PowerShell command.<\/p>\n<p>To demonstrate, here is the Exchange Management Shell command for using <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/dd298044(v=exchg.141).aspx\">Get-MailboxDatabaseCopyStatus<\/a> to display all database copies that have a content index in a failed state.<\/p>\n<div id=\"crayon-5b8d44a15d9db351615537\" class=\"crayon-syntax crayon-theme-powershell-custom crayon-font-consolas crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-expand-button\" title=\"Expand Code\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">[PS] C:\\&gt;Get-MailboxDatabaseCopyStatus * | where {$_.ContentIndexState -eq &#8220;Failed&#8221;}<\/p>\n<p>Name                               Status     CopyQueue ReplayQueue LastInspectedLogTime   ContentIndex<br \/>\n                                   Length     Length                                       State<br \/>\n&#8212;-                               &#8212;&#8212;     &#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;   &#8212;&#8212;&#8212;&#8212;<br \/>\nMailbox Database 1HO-EX2010-MB1   Healthy    0         0           22\/02\/2013 10:43:26 AM Failed<br \/>\nMailbox Database 2HO-EX2010-MB1   Healthy    0         0           22\/02\/2013 10:41:36 AM Failed<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5b8d44a15d9db351615537-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5b8d44a15d9db351615537-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5b8d44a15d9db351615537-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5b8d44a15d9db351615537-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5b8d44a15d9db351615537-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5b8d44a15d9db351615537-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5b8d44a15d9db351615537-7\">7<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5b8d44a15d9db351615537-1\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">PS<\/span><span class=\"crayon-sy\">]<\/span> <span class=\"crayon-v\">C<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-sy\">\\<\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-v\">Get<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e \">MailboxDatabaseCopyStatus *<\/span> <span class=\"crayon-o\">|<\/span> <span class=\"crayon-e\">where<\/span> <span class=\"crayon-sy\">{<\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-v\">_<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">ContentIndexState<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">eq<\/span> <span class=\"crayon-s\">&#8220;Failed&#8221;<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5b8d44a15d9db351615537-2\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5b8d44a15d9db351615537-3\" class=\"crayon-line\"><span class=\"crayon-e\">Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-e\">Status\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-e\">CopyQueue <\/span><span class=\"crayon-e\">ReplayQueue <\/span><span class=\"crayon-e\">LastInspectedLogTime\u00a0\u00a0 <\/span><span class=\"crayon-e\">ContentIndex<\/span><\/div>\n<div id=\"crayon-5b8d44a15d9db351615537-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-e\">Length\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-e\">Length\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-v\">State<\/span><\/div>\n<div id=\"crayon-5b8d44a15d9db351615537-5\" class=\"crayon-line\"><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><span class=\"crayon-o\">&#8212;<\/span><\/div>\n<div id=\"crayon-5b8d44a15d9db351615537-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">Mailbox <\/span><span class=\"crayon-i\">Database<\/span> <span class=\"crayon-cn\">1HO<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">EX2010<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">MB1\u00a0\u00a0 <\/span><span class=\"crayon-i\">Healthy<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-cn\">22<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-cn\">02<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-cn\">2013<\/span> <span class=\"crayon-cn\">10<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">43<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">26<\/span> <span class=\"crayon-e\">AM <\/span><span class=\"crayon-e\">Failed<\/span><\/div>\n<div id=\"crayon-5b8d44a15d9db351615537-7\" class=\"crayon-line\"><span class=\"crayon-e\">Mailbox <\/span><span class=\"crayon-i\">Database<\/span> <span class=\"crayon-cn\">2HO<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">EX2010<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">MB1\u00a0\u00a0 <\/span><span class=\"crayon-i\">Healthy<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-cn\">22<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-cn\">02<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-cn\">2013<\/span> <span class=\"crayon-cn\">10<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">41<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">36<\/span> <span class=\"crayon-e\">AM <\/span><span class=\"crayon-v\">Failed<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>So all we need to do is pipe the output of that command into the <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/dd335201(v=exchg.141).aspx\">Update-MailboxDatabaseCopy<\/a> cmdlet with the <strong>-CatalogOnly<\/strong> switch.<\/p>\n<div id=\"crayon-5b8d44a15d9e2635825341\" class=\"crayon-syntax crayon-theme-powershell-custom crayon-font-consolas crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-expand-button\" title=\"Expand Code\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">[PS] C:\\&gt;Get-MailboxDatabaseCopyStatus * | where {$_.ContentIndexState -eq &#8220;Failed&#8221;} | Update-MailboxDatabaseCopy -CatalogOnly<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5b8d44a15d9e2635825341-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5b8d44a15d9e2635825341-1\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">PS<\/span><span class=\"crayon-sy\">]<\/span> <span class=\"crayon-v\">C<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-sy\">\\<\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-v\">Get<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e \">MailboxDatabaseCopyStatus *<\/span> <span class=\"crayon-o\">|<\/span> <span class=\"crayon-e\">where<\/span> <span class=\"crayon-sy\">{<\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-v\">_<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">ContentIndexState<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">eq<\/span> <span class=\"crayon-s\">&#8220;Failed&#8221;<\/span><span class=\"crayon-sy\">}<\/span> <span class=\"crayon-o\">|<\/span> <span class=\"crayon-v\">Update<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">MailboxDatabaseCopy<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">CatalogOnly<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Wait for that process to complete, then re-run the first command again. If no results are returned this time then there are no more failed content indexes.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Source:https:\/\/practical365.com\/exchange-server\/fix-all-failed-exchange-database-content-indexes\/ One of the issues that my Get-DAGHealth.ps1 script alerts for is failed content indexes on database copies in a database availability group. Note: for failed content indexes on servers that are not DAG members refer to this article instead. Failed content indexes can easily go unnoticed when everything else is working fine however they [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,13,18],"tags":[],"class_list":["post-1048","post","type-post","status-publish","format-standard","hentry","category-exchange","category-novosti","category-powershell"],"_links":{"self":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/1048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1048"}],"version-history":[{"count":1,"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/1048\/revisions"}],"predecessor-version":[{"id":1049,"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/1048\/revisions\/1049"}],"wp:attachment":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}