Para acompanhar as altera\u00e7\u00f5es, utilizei a query abaixo ap\u00f3s cada altera\u00e7\u00e3o de status do Mirror:<\/p>\n
SELECT db.name, mirroring_state_desc, mirroring_safety_level_desc,mirroring_witness_state_desc<\/p>\n
FROM sys.database_mirroring m<\/p>\n
JOIN sys.databases db ON db.database_id = m.database_id<\/p>\n
where name = ‘Mirror1’ \u2013Nome da database espelhada<\/p>\n
Teste 1: High Safety with Automatic Failover\u00a0 =>\u00a0 High Safety without Automatic Failover<\/strong><\/p>\n Para realizar essa altera\u00e7\u00e3o, o comando abaixo deve ser executado:<\/p>\n USE [master]\n GO<\/p>\n ALTER DATABASE [Mirror1] SET WITNESS OFF<\/p>\n Conferindo com a query de acompanhamento, temos o resultado:<\/p>\n <\/p>\n <\/span><\/p>\n \n Safety_Level\u00a0 FULL + Witness_State UNKNOWN = High Safety without Automatic Failover<\/em><\/p>\n Volta: High Safety without Automatic Failover => High Safety with Automatic Failover<\/strong><\/p>\n 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 Para adicionar um servidor de WITNESS em um Database Mirroring, o comando abaixo deve ser executado:<\/p>\n USE [master]\n GO<\/p>\n ALTER DATABASE [Mirror1] SET WITNESS = N’TCP:\/\/Ambiente5.lab.local:5024′<\/p>\n Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n \n \n Safety_Level\u00a0 FULL + Witness_State CONNECTED = High Safety without Automatic Failover<\/em><\/p>\n <\/span>Teste 2: High Safety with Automatic Failover => High Performance<\/strong><\/p>\n Para realizar essa altera\u00e7\u00e3o, os comandos abaixo devem ser executados:<\/p>\n USE [master]\n ALTER DATABASE [Mirror1] SET WITNESS OFF<\/p>\n GO<\/p>\n ALTER DATABASE [Mirror1] SET SAFETY OFF<\/p>\n Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n \n Safety_Level\u00a0 OFF + Witness_State UNKNOWN = High Performance<\/em><\/p>\n Volta: High Performance =>High Safety with Automatic Failover<\/strong><\/p>\n Para realizar essa altera\u00e7\u00e3o, os comandos abaixo devem ser executados:<\/p>\n USE [master]\n GO<\/p>\n ALTER DATABASE [Mirror1] SET SAFETY FULL<\/p>\n GO<\/p>\n ALTER DATABASE [Mirror1] SET WITNESS = N’TCP:\/\/Ambiente5.lab.local:5024′<\/p>\n GO<\/p>\n Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n \n <\n\n\n Safety_Level\u00a0 FULL + Witness_State CONNECTED = High Safety with Automatic Failover<\/em><\/p>\n Teste 3 – High Safety without Automatic Failover => High Performance<\/strong><\/p>\n Para realizar essa altera\u00e7\u00e3o, o comando abaixo deve ser executado:<\/p>\n USE [master]\n GO<\/p>\n ALTER DATABASE [Mirror1] SET SAFETY OFF<\/p>\n Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n Safety_Level\u00a0 OFF + Witness_State UNKNOWN = High Performance<\/em><\/p>\n Volta: High Performance => High Safety without Automatic Failover<\/strong><\/p>\n Para realizar essa altera\u00e7\u00e3o, o comando abaixo deve ser executado:<\/p>\n USE [master]\n GO<\/p>\n ALTER DATABASE [Mirror1] SET SAFETY FULL<\/p>\n Resultado ap\u00f3s a altera\u00e7\u00e3o:<\/p>\n![\"\"](\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2012\/03\/Figura1.png\" "\\"Figura1\\"")
<\/a><\/span><\/p>\n\n
<\/a><\/span><\/p>\n<\/a><\/span><\/p>\n<\/a><\/span><\/p>\n<\/a><\/span><\/p>\n