{"id":1594,"date":"2012-07-18T13:32:44","date_gmt":"2012-07-18T15:32:44","guid":{"rendered":"http:\/\/fabriciolima.net\/blog\/?p=1594"},"modified":"2016-07-24T10:22:27","modified_gmt":"2016-07-24T13:22:27","slug":"database-mirroring-operation-mode-high-safety-without-failover-parte-3","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/","title":{"rendered":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3"},"content":{"rendered":"<p>Fala Pessoal,<\/p>\n<p>Neste post continuarei com o teste do Operation Mode High Safety Without  Automatic Failover.  Caso ainda n\u00e3o tenham visto os posts anteriores,  sugiro que  os leia  antes de continuar:<\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/06\/27\/database-mirroring-operation-mode-high-safety-without-failover-parte-1\/\" target=\"_blank\">Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1<\/a><\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/06\/29\/database-mirroring-operation-mode-high-safety-without-failover-parte-2\/\" target=\"_blank\">Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2<\/a><\/p>\n<p><strong>O Objetivo deste teste \u00e9 parar o servidor Principal, acabar com o Mirror, subir o servidor Principal e verificar se houve alguma perda de dados.<\/strong><\/p>\n<p>Iniciei o loop de Insert sem waitfor delay:<br \/>\nwhile 1=1<br \/>\nbegin<br \/>\nif exists (select null<br \/>\nfrom sys.databases<br \/>\nwhere name = &#8216;MIRROR1&#8217; and state_desc = &#8216;ONLINE&#8217;)<br \/>\ninsert into mirror1..Teste(texto)<br \/>\nselect @@servername<br \/>\nend<\/p>\n<p>Caso um problema aconte\u00e7a com o seu servidor A (principal) o mirror fica conforme abaixo:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1673\" title=\"Figura 1\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11.png\" alt=\"\" width=\"523\" height=\"81\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11.png 523w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11-300x46.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11-410x63.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11-100x15.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11-275x43.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11-20x3.png 20w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/a><\/p>\n<p>Nesse momento, como nesse operation mode n\u00e3o temos um failover autom\u00e1tico, o mirror fica nesse status at\u00e9 que o servidor A volte ou voc\u00ea fa\u00e7a um failover manual.<\/p>\n<p>Conforme mostrei no post anterior:<\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/07\/16\/database-mirroring-error-the-command-failed-because-the-database-mirror-is-busy\/\" target=\"_blank\">Database Mirroring \u2013 Error: The Command Failed Because The Database Mirror Is  Busy<\/a><\/p>\n<p>N\u00e3o \u00e9 poss\u00edvel fazer um failover manual nessa situa\u00e7\u00e3o.<\/p>\n<p>Caso voc\u00ea n\u00e3o possa esperar o servidor A voltar, a \u00fanica solu\u00e7\u00e3o \u00e9 parar o mirror conforme os scripts:<\/p>\n<p>ALTER DATABASE mirror1 SET PARTNER OFF<br \/>\nGO<br \/>\nRESTORE DATABASE mirror1 WITH RECOVERY<\/p>\n<p>Executando os comandos acima, a database mirror1 j\u00e1 fica dispon\u00edvel no servidor B.<\/p>\n<p>Ao subir novamente o servidor A, a database mirror1 desse servidor tamb\u00e9m fica dispon\u00edvel.<\/p>\n<p>Nesse momento, deve-se ter certeza que as aplica\u00e7\u00f5es e servi\u00e7os est\u00e3o apontando para apenas um servidor.<\/p>\n<p>Para verificar se houve perda de dados com a quebra do mirror, executei a seguinte query nos dois servidores para pegar o \u00faltimo registro que foi inserido no servidor A com o texto \u2018ambiente5\u2019 e comparar com o \u00faltimo registro com essa informa\u00e7\u00e3o que foi sincronizado com o servidor B:<\/p>\n<p>select top 1 Cod, Data, Texto<br \/>\nfrom mirror1..Teste<br \/>\nwhere Texto = &#8216;ambiente5&#8217;<br \/>\norder by data desc<\/p>\n<p>Resultado no servidor A (Ambiente5):<\/p>\n<p>300.866\u00a0\u00a0 \u00a02012-01-31 14:00:37.250\u00a0\u00a0 \u00a0Ambiente5<\/p>\n<p>Resultado servidor B (Ambiente5\\inst1):<\/p>\n<p>300.866\u00a0\u00a0 \u00a02012-01-31 14:00:37.250\u00a0\u00a0 \u00a0Ambiente5<\/p>\n<p>Ou seja, o \u00faltimo registro inserido no servidor A foi transferido para o servidor B. N\u00e3o tive perda de dados.<\/p>\n<p>Conforme era esperado, como meu mirror estava sincronizado e no modo High Safety, n\u00e3o tive perda de dados, entretanto, tivemos que acabar com o mirror. Caso o tamanho da database seja muito grande, a reconstru\u00e7\u00e3o de um database mirror pode demorar horas. Se n\u00e3o for poss\u00edvel esperar todo esse tempo para um ambiente cr\u00edtico, deve-se utilizar o operation mode High Safety With Automatic Failover.<\/p>\n<p>Artigos relacionados:<\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/05\/15\/serie-de-posts-sobre-database-mirroring\/\" target=\"_blank\">S\u00e9rie de Posts sobre Database Mirroring<\/a><\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/\" target=\"_blank\">Database Mirroring \u2013 Como alterar o Operation Mode<\/a><\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/05\/23\/database-mirroring-testes-operation-mode-high-performance-parte-1\/\" target=\"_blank\">Database Mirroring \u2013 Operation Mode High Performance \u2013 Parte 1<\/a><\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/05\/28\/database-mirroring-operation-mode-high-performance-parte-2\/\" target=\"_blank\">Database Mirroring \u2013 Operation Mode High Performance \u2013 Parte 2<\/a><\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/05\/31\/database-mirroring-operation-mode-high-performance-parte-3\/\" target=\"_blank\">Database Mirroring &#8211; Operation Mode High Performance &#8211; Parte 3<\/a><\/p>\n<p><a rel=\"bookmark\" href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/06\/27\/database-mirroring-operation-mode-high-safety-without-failover-parte-1\/\" target=\"_blank\">Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013  Parte 1<\/a><\/p>\n<p><a rel=\"bookmark\" href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/06\/29\/database-mirroring-operation-mode-high-safety-without-failover-parte-2\/\" target=\"_blank\">Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013  Parte 2<\/a><\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2012\/07\/16\/database-mirroring-error-the-command-failed-because-the-database-mirror-is-busy\/\" target=\"_blank\">Database Mirroring \u2013 Error: The Command Failed Because The Database Mirror Is  Busy<\/a><\/p>\n<p>At\u00e9 o pr\u00f3ximo post.<\/p>\n<p><b>Gostou desse Post?<\/b><\/p>\n<p>Cadastre seu e-mail para receber novos Posts e curta minha <a href=\"https:\/\/www.facebook.com\/FabricioLimaSolucoesemBancodeDados\/\" target=\"_blank\">P\u00e1gina no Facebook<\/a> para receber Dicas de Leituras e Eventos sobre SQL Server.<\/p>\n<p>Abra\u00e7os,<\/p>\n<p>Fabr\u00edcio Lima<\/p>\n<p>MCITP \u2013 Database Administrator<\/p>\n<p>Consultor e Instrutor SQL Server<\/p>\n<p>Trabalha com SQL Server desde 2006<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[3,280],"tags":[604,606,391,23,607,372,613,611,612,610,608,616,49,33,50,34,605,609,614,615],"class_list":["post-1594","post","type-post","status-publish","format-standard","hentry","category-administracao-de-bd","category-virtual-pass-br","tag-alta-disponibilidade","tag-database-mirror","tag-database-mirroring","tag-dba","tag-espelhamento-de-banco-de-dados","tag-high-availability","tag-high-performance","tag-high-safety-with-automatic-failover","tag-high-safety-without-automatic-failover","tag-operation-mode","tag-perda-de-dados","tag-safety","tag-sql","tag-sql-server","tag-sql-server-2005","tag-sql-server-2008","tag-sql-server-mirror","tag-sql-server-online","tag-sys-database_mirroring","tag-witness"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Fabr\u00edcio Lima\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta property=\"og:description\" content=\"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-07-18T15:32:44+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-07-24T13:22:27+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#blogposting\",\"name\":\"Database Mirroring \\u2013 Operation Mode High Safety Without Failover \\u2013 Parte 3 - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"headline\":\"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3\",\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.fabriciolima.net\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/07\\\/Figura-11.png\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#articleImage\"},\"datePublished\":\"2012-07-18T13:32:44-03:00\",\"dateModified\":\"2016-07-24T10:22:27-03:00\",\"inLanguage\":\"pt-BR\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#webpage\"},\"articleSection\":\"Administra\\u00e7\\u00e3o de Banco de Dados, Virtual PASS BR, alta disponibilidade, Database Mirror, Database Mirroring, DBA, Espelhamento de banco de dados, High Availability, High Performance, High Safety with Automatic Failover, High Safety without Automatic Failover, Operation Mode, Perda de dados, Safety, SQL, SQL Server, SQL Server 2005, SQL Server 2008, sql server mirror, sql server online, sys.database_mirroring, WITNESS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"position\":2,\"name\":\"SQL Server\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"position\":3,\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#listItem\",\"name\":\"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#listItem\",\"position\":4,\"name\":\"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/\",\"name\":\"Fabr\\u00edcio Lima\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Fabr\\u00edcio Lima\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#webpage\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/\",\"name\":\"Database Mirroring \\u2013 Operation Mode High Safety Without Failover \\u2013 Parte 3 - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \\u2013 Operation Mode High Safety Without Failover \\u2013 Parte 1 Database Mirroring \\u2013 Operation Mode High Safety Without Failover \\u2013 Parte 2\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/07\\\/18\\\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"datePublished\":\"2012-07-18T13:32:44-03:00\",\"dateModified\":\"2016-07-24T10:22:27-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2","canonical_url":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#blogposting","name":"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA","headline":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3","author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/07\/Figura-11.png","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#articleImage"},"datePublished":"2012-07-18T13:32:44-03:00","dateModified":"2016-07-24T10:22:27-03:00","inLanguage":"pt-BR","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#webpage"},"isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#webpage"},"articleSection":"Administra\u00e7\u00e3o de Banco de Dados, Virtual PASS BR, alta disponibilidade, Database Mirror, Database Mirroring, DBA, Espelhamento de banco de dados, High Availability, High Performance, High Safety with Automatic Failover, High Safety without Automatic Failover, Operation Mode, Perda de dados, Safety, SQL, SQL Server, SQL Server 2005, SQL Server 2008, sql server mirror, sql server online, sys.database_mirroring, WITNESS"},{"@type":"BreadcrumbList","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/fabriciolima.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","position":2,"name":"SQL Server","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","name":"Administra\u00e7\u00e3o de Banco de Dados"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","position":3,"name":"Administra\u00e7\u00e3o de Banco de Dados","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#listItem","name":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#listItem","position":4,"name":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3","previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","name":"Administra\u00e7\u00e3o de Banco de Dados"}}]},{"@type":"Organization","@id":"https:\/\/fabriciolima.net\/blog\/#organization","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","url":"https:\/\/fabriciolima.net\/blog\/"},{"@type":"Person","@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author","url":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/","name":"Fabr\u00edcio Lima","image":{"@type":"ImageObject","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g","width":96,"height":96,"caption":"Fabr\u00edcio Lima"}},{"@type":"WebPage","@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#webpage","url":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/","name":"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/#breadcrumblist"},"author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"creator":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"datePublished":"2012-07-18T13:32:44-03:00","dateModified":"2016-07-24T10:22:27-03:00"},{"@type":"WebSite","@id":"https:\/\/fabriciolima.net\/blog\/#website","url":"https:\/\/fabriciolima.net\/blog\/","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","og:type":"article","og:title":"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA","og:description":"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2","og:url":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/","article:published_time":"2012-07-18T15:32:44+00:00","article:modified_time":"2016-07-24T13:22:27+00:00","twitter:card":"summary_large_image","twitter:title":"Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3 - Fabricio Lima | Neg\u00f3cios, Dados e IA","twitter:description":"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenham visto os posts anteriores, sugiro que os leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 2"},"aioseo_meta_data":{"post_id":"1594","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-04 23:19:40","updated":"2026-07-04 23:19:40"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/\" title=\"SQL Server\">SQL Server<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/\" title=\"Administra\u00e7\u00e3o de Banco de Dados\">Administra\u00e7\u00e3o de Banco de Dados<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tDatabase Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 3\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/fabriciolima.net\/blog"},{"label":"SQL Server","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/"},{"label":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},{"label":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3","link":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/"}],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1520,"url":"https:\/\/fabriciolima.net\/blog\/2012\/06\/27\/database-mirroring-operation-mode-high-safety-without-failover-parte-1\/","url_meta":{"origin":1594,"position":0},"title":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 1","author":"Fabr\u00edcio Lima","date":"27 de junho de 2012","format":false,"excerpt":"Fala Pessoal, Nesse post come\u00e7o a testar como o Database Mirroring se comporta configurado com o Operation mode High Safety Without Automatic Failover. Inst\u00e2ncias participantes dos testes: 1 - Instancia5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 - Servidor Principal, referenciado no texto por Servidor A 2 - Instancia5\\INST1\u00a0\u00a0\u00a0 - Servidor Mirror, referenciado no texto por Servidor\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/05\/Figura1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1523,"url":"https:\/\/fabriciolima.net\/blog\/2012\/06\/29\/database-mirroring-operation-mode-high-safety-without-failover-parte-2\/","url_meta":{"origin":1594,"position":1},"title":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 2","author":"Fabr\u00edcio Lima","date":"29 de junho de 2012","format":false,"excerpt":"Fala Pessoal, Neste post continuarei com o teste do Operation Mode High Safety Without Automatic Failover. Caso ainda n\u00e3o tenha visto o post anterior, sugiro que o leia antes de continuar: Database Mirroring \u2013 Operation Mode High Safety Without Failover \u2013 Parte 1 Nesse teste foi simulado um problema com\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/05\/Figura11.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1637,"url":"https:\/\/fabriciolima.net\/blog\/2012\/11\/08\/database-mirroring-tempo-failover-hs-without-automatic-failover\/","url_meta":{"origin":1594,"position":2},"title":"Database Mirroring &#8211; Tempo Failover &#8211; HS Without Automatic Failover","author":"Fabr\u00edcio Lima","date":"8 de novembro de 2012","format":false,"excerpt":"Ol\u00e1 Pessoal, A ideia desse teste \u00e9 verificar o tempo que o Database Mirroring leva para fazer um failover manual de um servidor para o outro utilizando esse Operation mode. Inst\u00e2ncias participantes dos testes: 1 - Instancia5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 - Servidor Principal, referenciado no texto por Servidor A 2 - Instancia5\\INST1\u00a0\u00a0\u00a0 -\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/11\/Figura-14.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1629,"url":"https:\/\/fabriciolima.net\/blog\/2012\/10\/31\/database-mirroring-operation-mode-high-safety-with-automatic-failover\/","url_meta":{"origin":1594,"position":3},"title":"Database Mirroring &#8211; Operation Mode High Safety with Automatic Failover","author":"Fabr\u00edcio Lima","date":"31 de outubro de 2012","format":false,"excerpt":"Fala Pessoal, A ideia desse teste \u00e9 verificar o tempo que o Database Mirroring leva para fazer um failover autom\u00e1tico de um servidor para o outro utilizando esse Operation mode. Inst\u00e2ncias participantes dos testes: 1 - Instancia5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 - Servidor Principal, referenciado no texto por Servidor A 2 - Instancia5\\INST1\u00a0\u00a0\u00a0 -\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/10\/Figura-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1399,"url":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/","url_meta":{"origin":1594,"position":4},"title":"Database Mirroring &#8211; Como alterar o Operation Mode","author":"Fabr\u00edcio Lima","date":"15 de maio de 2012","format":false,"excerpt":"Fala Pessoal, Nesse primeiro teste, realizei todas as altera\u00e7\u00f5es de Operations Mode poss\u00edveis em um Database Mirroring. Os 3 operations mode poss\u00edveis s\u00e3o: High Safety with Automatic Failover. High Safety without Automatic Failover. High Performance. Para acompanhar as altera\u00e7\u00f5es, utilizei a query abaixo ap\u00f3s cada altera\u00e7\u00e3o de status do Mirror:\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1631,"url":"https:\/\/fabriciolima.net\/blog\/2013\/01\/01\/database-mirroring-tirando-o-servidor-de-witness-do-mirror-em-caso-de-falha\/","url_meta":{"origin":1594,"position":5},"title":"Database Mirroring &#8211; Tirando o servidor de Witness do Mirror em caso de falha","author":"Fabr\u00edcio Lima","date":"1 de janeiro de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Continuando a s\u00e9rie de posts sobre Database Mirroring que j\u00e1 tenho semi prontos (faltam mais 3 posts ap\u00f3s esse), segue mais um teste realizado. O objetivo desse teste \u00e9 provar que o servidor de produ\u00e7\u00e3o em um Mirror pode parar mesmo sem acontecer nenhum problema com ele. Em\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/11\/Figura-1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/11\/Figura-1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/11\/Figura-1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/11\/Figura-1.png?resize=700%2C400&ssl=1 2x"},"classes":[]}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/1594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/comments?post=1594"}],"version-history":[{"count":0,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/1594\/revisions"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=1594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=1594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=1594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}