{"id":1399,"date":"2012-05-15T22:49:33","date_gmt":"2012-05-16T00:49:33","guid":{"rendered":"http:\/\/fabriciolima.net\/blog\/?p=1399"},"modified":"2016-07-24T10:20:18","modified_gmt":"2016-07-24T13:20:18","slug":"database-mirroring-como-alterar-o-operation-mode","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/","title":{"rendered":"Database Mirroring &#8211; Como alterar o Operation Mode"},"content":{"rendered":"<p>Fala Pessoal,<\/p>\n<p>Nesse primeiro teste, realizei todas as altera\u00e7\u00f5es de Operations Mode poss\u00edveis em um Database Mirroring.<\/p>\n<p>Os 3 operations mode poss\u00edveis s\u00e3o:<\/p>\n<ul>\n<li> High Safety with Automatic Failover.<\/li>\n<li>High Safety without Automatic Failover.<\/li>\n<li>High Performance.<\/li>\n<\/ul>\n<p>Para acompanhar as altera\u00e7\u00f5es, utilizei a query abaixo ap\u00f3s cada altera\u00e7\u00e3o de status do Mirror:<\/p>\n<p>SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc<\/p>\n<p>FROM sys.database_mirroring m<\/p>\n<p>JOIN sys.databases db ON db.database_id = m.database_id<\/p>\n<p>where name = &#8216;Mirror1&#8217; \u2013Nome da database espelhada<\/p>\n<p><strong>Teste 1: High Safety with Automatic Failover\u00a0 =&gt;\u00a0 High Safety without Automatic Failover<\/strong><\/p>\n<p>Para realizar essa altera\u00e7\u00e3o, o comando abaixo deve ser executado:<\/p>\n<p>USE [master]\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET WITNESS OFF<\/p>\n<p>Conferindo com a query de acompanhamento, temos o resultado:<\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp;\"><\/p>\n<p><\/span><\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt; text-align: center;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp;\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1402\" title=\"Figura1\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png\" alt=\"\" width=\"508\" height=\"68\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png 508w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-300x40.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-410x55.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-100x13.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-275x37.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-20x3.png 20w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/a><\/span><\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt; text-align: left;\">\n<p><em>Safety_Level\u00a0 FULL + Witness_State UNKNOWN = High Safety without Automatic Failover<\/em><\/p>\n<p><strong>Volta: High Safety without Automatic Failover =&gt; High Safety with Automatic Failover<\/strong><\/p>\n<p>Para identificar o servidor de Witness, deve-se executar um IPCONFIG \/all e pegar as informa\u00e7\u00f5es de HostName e Primary DNS Suffix:<\/p>\n<ul>\n<li> Host Name: Ambiente5<\/li>\n<li> Primary DNS Suffix: lab.local<\/li>\n<li> Completando a string tempos a porta utilizada pelo Endpoint desse servidor: 5024<\/li>\n<\/ul>\n<p>Para adicionar um servidor de WITNESS em um Database Mirroring, o comando abaixo deve ser executado:<\/p>\n<p>USE [master]\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET WITNESS = N&#8217;TCP:\/\/Ambiente5.lab.local:5024&#8242;<\/p>\n<p>Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt;\">\n<p style=\"margin: 0cm 0cm 0.0001pt; text-align: center;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp; color: black;\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1403\" title=\"Figura2\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2.png\" alt=\"\" width=\"508\" height=\"63\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2.png 508w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-300x37.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-410x51.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-100x12.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-275x34.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-20x2.png 20w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/a><\/span><\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt; text-align: center;\">\n<p><em>Safety_Level\u00a0 FULL + Witness_State CONNECTED = High Safety without Automatic Failover<\/em><\/p>\n<p><span style=\"font-size: 11pt; font-family: &amp;amp;amp; color: black;\"> <\/span><strong>Teste 2: High Safety with Automatic Failover =&gt; High Performance<\/strong><\/p>\n<p>Para realizar essa altera\u00e7\u00e3o, os comandos abaixo devem ser executados:<\/p>\n<p>USE [master]\n<p>ALTER DATABASE [Mirror1] SET WITNESS OFF<\/p>\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET SAFETY OFF<\/p>\n<p>Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt;\">\n<p style=\"margin: 0cm 0cm 0.0001pt; text-align: center;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp; color: black;\" lang=\"EN-US\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1404\" title=\"Figura3\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3.png\" alt=\"\" width=\"511\" height=\"70\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3.png 511w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-300x41.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-410x56.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-100x14.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-275x38.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-20x3.png 20w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/a><\/span><\/p>\n<p><em>Safety_Level\u00a0 OFF + Witness_State UNKNOWN = High Performance<\/em><\/p>\n<p><strong>Volta: High Performance =&gt;High Safety with Automatic Failover<\/strong><\/p>\n<p>Para realizar essa altera\u00e7\u00e3o, os comandos abaixo devem ser executados:<\/p>\n<p>USE [master]\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET SAFETY FULL<\/p>\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET WITNESS = N&#8217;TCP:\/\/Ambiente5.lab.local:5024&#8242;<\/p>\n<p>GO<\/p>\n<p>Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n<p style=\"margin: 0cm 0cm 0.0001pt;\">\n<p style=\"margin: 0cm 0cm 0.0001pt; text-align: center;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp; color: black;\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1403\" title=\"Figura2\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2.png\" alt=\"\" width=\"508\" height=\"63\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2.png 508w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-300x37.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-410x51.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-100x12.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-275x34.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura2-20x2.png 20w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/a><\/span><\/p>\n<p><\n\n\n<p><em>Safety_Level\u00a0 FULL + Witness_State CONNECTED = High Safety with Automatic Failover<\/em><\/p>\n<p><strong>Teste 3 &#8211; High Safety without Automatic Failover =&gt; High Performance<\/strong><\/p>\n<p>Para realizar essa altera\u00e7\u00e3o, o comando abaixo deve ser executado:<\/p>\n<p>USE [master]\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET SAFETY OFF<\/p>\n<p>Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n<p style=\"text-align: center;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp; color: black;\" lang=\"EN-US\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1404\" title=\"Figura3\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3.png\" alt=\"\" width=\"511\" height=\"70\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3.png 511w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-300x41.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-410x56.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-100x14.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-275x38.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura3-20x3.png 20w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/a><\/span><\/p>\n<p><em>Safety_Level\u00a0 OFF + Witness_State UNKNOWN = High Performance<\/em><\/p>\n<p><strong>Volta: High Performance =&gt; High Safety without Automatic Failover<\/strong><\/p>\n<p>Para realizar essa altera\u00e7\u00e3o, o comando abaixo deve ser executado:<\/p>\n<p>USE [master]\n<p>GO<\/p>\n<p>ALTER DATABASE [Mirror1] SET SAFETY FULL<\/p>\n<p>Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n<p style=\"margin: 0cm; margin-bottom: .0001pt;\"><span style=\"font-size: 11.0pt; font-family: &amp;amp;amp; color: black; mso-ansi-language: EN-US;\" lang=\"EN-US\"><\/p>\n<p><\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-size: 11pt; font-family: &amp;amp;amp;\"><a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1402\" title=\"Figura1\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png\" alt=\"\" width=\"508\" height=\"68\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png 508w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-300x40.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-410x55.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-100x13.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-275x37.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1-20x3.png 20w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/a><\/span><\/p>\n<p><em>Safety_Level\u00a0 FULL + Witness_State UNKNOWN = High Safety without Automatic Failover<\/em><\/p>\n<p>Com esse Post j\u00e1 temos um resumo de como alternar entre os Operations Mode do Database Mirroring. Ap\u00f3s alguns testes, todas essas altera\u00e7\u00f5es j\u00e1 ficam na sua cabe\u00e7a.<\/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, 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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM [&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-1399","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, 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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM\" \/>\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\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/\" \/>\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 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta property=\"og:description\" content=\"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-05-16T00:49:33+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-07-24T13:20:18+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Database Mirroring \u2013 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta name=\"twitter:description\" content=\"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM\" \/>\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\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#blogposting\",\"name\":\"Database Mirroring \\u2013 Como alterar o Operation Mode - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"headline\":\"Database Mirroring &#8211; Como alterar o Operation Mode\",\"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\\\/03\\\/Figura1.png\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#articleImage\"},\"datePublished\":\"2012-05-15T22:49:33-03:00\",\"dateModified\":\"2016-07-24T10:20:18-03:00\",\"inLanguage\":\"pt-BR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#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\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#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\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#listItem\",\"name\":\"Database Mirroring &#8211; Como alterar o Operation Mode\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#listItem\",\"position\":4,\"name\":\"Database Mirroring &#8211; Como alterar o Operation Mode\",\"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\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#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\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#webpage\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/\",\"name\":\"Database Mirroring \\u2013 Como alterar o Operation Mode - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2012\\\/05\\\/15\\\/database-mirroring-como-alterar-o-operation-mode\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"datePublished\":\"2012-05-15T22:49:33-03:00\",\"dateModified\":\"2016-07-24T10:20:18-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 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM","canonical_url":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#blogposting","name":"Database Mirroring \u2013 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA","headline":"Database Mirroring &#8211; Como alterar o Operation Mode","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\/03\/Figura1.png","@id":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#articleImage"},"datePublished":"2012-05-15T22:49:33-03:00","dateModified":"2016-07-24T10:20:18-03:00","inLanguage":"pt-BR","mainEntityOfPage":{"@id":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#webpage"},"isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#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\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#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\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#listItem","name":"Database Mirroring &#8211; Como alterar o Operation Mode"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#listItem","position":4,"name":"Database Mirroring &#8211; Como alterar o Operation Mode","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\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#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\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#webpage","url":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/","name":"Database Mirroring \u2013 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/#breadcrumblist"},"author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"creator":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"datePublished":"2012-05-15T22:49:33-03:00","dateModified":"2016-07-24T10:20:18-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 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA","og:description":"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM","og:url":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/","article:published_time":"2012-05-16T00:49:33+00:00","article:modified_time":"2016-07-24T13:20:18+00:00","twitter:card":"summary_large_image","twitter:title":"Database Mirroring \u2013 Como alterar o Operation Mode - Fabricio Lima | Neg\u00f3cios, Dados e IA","twitter:description":"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: SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc FROM"},"aioseo_meta_data":{"post_id":"1399","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 Como alterar o Operation Mode\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; Como alterar o Operation Mode","link":"https:\/\/fabriciolima.net\/blog\/2012\/05\/15\/database-mirroring-como-alterar-o-operation-mode\/"}],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1594,"url":"https:\/\/fabriciolima.net\/blog\/2012\/07\/18\/database-mirroring-operation-mode-high-safety-without-failover-parte-3\/","url_meta":{"origin":1399,"position":0},"title":"Database Mirroring &#8211; Operation Mode High Safety Without Failover &#8211; Parte 3","author":"Fabr\u00edcio Lima","date":"18 de julho 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 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\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\/07\/Figura-11.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1520,"url":"https:\/\/fabriciolima.net\/blog\/2012\/06\/27\/database-mirroring-operation-mode-high-safety-without-failover-parte-1\/","url_meta":{"origin":1399,"position":1},"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":1637,"url":"https:\/\/fabriciolima.net\/blog\/2012\/11\/08\/database-mirroring-tempo-failover-hs-without-automatic-failover\/","url_meta":{"origin":1399,"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":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":1399,"position":3},"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":[]},{"id":1645,"url":"https:\/\/fabriciolima.net\/blog\/2013\/01\/11\/database-mirroring-failover-manual-de-varias-bases-ao-mesmo-tempo\/","url_meta":{"origin":1399,"position":4},"title":"Database Mirroring &#8211; Failover manual de v\u00e1rias bases ao mesmo tempo","author":"Fabr\u00edcio Lima","date":"11 de janeiro de 2013","format":false,"excerpt":"Ol\u00e1 Pessoal, Como a solu\u00e7\u00e3o de Database Mirroring do SQL Server \u00e9 em n\u00edvel de database, caso uma database fique indispon\u00edvel, apenas ela sofrer\u00e1 um failover para outra instancia do SQL Server (utilizando o Operation Mode High Safety with Automatic Failover). Entretanto, \u00e9 muito comum existir sistemas que utilizam v\u00e1rias\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":"","width":0,"height":0},"classes":[]},{"id":1629,"url":"https:\/\/fabriciolima.net\/blog\/2012\/10\/31\/database-mirroring-operation-mode-high-safety-with-automatic-failover\/","url_meta":{"origin":1399,"position":5},"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":[]}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/1399","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=1399"}],"version-history":[{"count":0,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/1399\/revisions"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=1399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=1399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=1399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}