{"id":5071,"date":"2019-01-06T19:53:33","date_gmt":"2019-01-06T19:53:33","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=5071"},"modified":"2019-02-28T08:09:06","modified_gmt":"2019-02-28T08:09:06","slug":"sql-server-alwayson-4","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-alwayson-4\/","title":{"rendered":"SQL Server AlwaysOn -4"},"content":{"rendered":"

Merhaba Arkada\u015flar,<\/p>\n

Bu yaz\u0131mda SQL Server AlwaysOn u anlatmaya devam edece\u011fim. Bu yaz\u0131mda Bir \u00f6nceki<\/a> yaz\u0131lar\u0131m\u0131n devam\u0131 niteli\u011findedir.<\/p>\n

\"\"<\/p>\n

<\/p>\n\n

\u00d6nceki yaz\u0131mda Manuel Failover testi yapm\u0131\u015ft\u0131m bu yaz\u0131mda Automatic Failover ve AlwaysOn a yeni Veritaban\u0131 eklemeyi g\u00f6sterece\u011fim. SQL Server AlwaysOn u Windows Failover Cluster Manager danda a\u015fa\u011f\u0131daki gibi kontrol edebiliriz. Roles sekmesinden bakt\u0131\u011f\u0131m\u0131z zaman AlwaysOn name ini statusunu ve Owner Node unu g\u00f6rebiliriz.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

SQLC1 Instance s\u0131na stop veriyorum yada Sunucuyuda kapatarak bu testi yapabilirsiniz.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

AlwaysOn dashboard da bakt\u0131\u011f\u0131m zaman a\u015fa\u011f\u0131daki gibi SQLC2 nin primary oldu\u011funu g\u00f6r\u00fcyoruz.<\/p>\n

\"\" \"\"<\/p>\n

SQLC1 i tekrar a\u00e7t\u0131\u011f\u0131mda senkron olup Secondary mode da \u00e7al\u0131\u015fmaya devam ediyor.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Ayn\u0131 testi gidip SQLC2 de yap\u0131yoruz ve SQLC2 yi restart ediyoruz a\u00e7\u0131l\u0131nca SQLC2 Secondary SQLC1 Primary olacak.<\/p>\n

\"\"<\/p>\n

SQLC2 restart sonras\u0131 SQLC1 primary oldu.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

AlwaysOn a yeni bir Veritaban\u0131 eklemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar yap\u0131l\u0131r.<\/p>\n

\"\"
\n\"\"<\/p>\n

Burdan Veritaban\u0131n\u0131 se\u00e7iyoruz.<\/p>\n

\"\"<\/p>\n

FULL olarak senkron edece\u011fiz b\u00f6ylece Backup al\u0131p restore etme i\u015flemini kendisi yapacakt\u0131r.<\/p>\n

\"\"<\/p>\n

Secondary Replica y\u0131 se\u00e7iyoruz.<\/p>\n

\"\"<\/p>\n

AlwaysOn a yeni veritaban\u0131 eklemeyi ba\u015flat\u0131yoruz.<\/p>\n

\"\" \"\"<\/p>\n

 <\/p>\n

Yeni Veritaban\u0131 a\u015fa\u011f\u0131daki gibi eklenmi\u015f oldu.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Tekrar SQL Server AlwaysOn dashboard a bakt\u0131\u011f\u0131m\u0131z zaman TESTDB ve POCDB nin eklenmi\u015f oldu\u011funu g\u00f6r\u00fcyoruz.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Herhangi bir Veritaban\u0131n\u0131 AlwaysOn dan \u00e7\u0131karmak i\u00e7inde a\u015fa\u011f\u0131daki y\u00f6ntem izlenir.<\/p>\n

\"\" \"\"<\/p>\n

 <\/p>\n

B\u00f6ylece bu yaz\u0131n\u0131nda sonuna gelmi\u015f bulunmaktay\u0131m bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle esen kal\u0131n…<\/p>\n

 <\/p>\n\n

 <\/p>\n

Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n

– Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Exadata Bak\u0131m ve Destek<\/span>
\n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Goldengate Bak\u0131m ve Destek<\/span>
\n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Linux Bak\u0131m ve Destek<\/span>
\n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EBS Bak\u0131m ve Destek<\/span>
\n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Weblogic Bak\u0131m ve Destek<\/span>
\n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
\n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle VM Server Bak\u0131m ve Destek<\/span>
\n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EPPM Bak\u0131m ve Destek<\/span>
\n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Primavera Bak\u0131m ve Destek<\/span>
\n– Oracle E\u011fitimleri<\/span>
\n– SQL Server E\u011fitimleri<\/span>
\n– Goldengate E\u011fitimleri<\/span>
\n– Exadata E\u011fitimleri<\/span>
\n– Linux E\u011fitimleri<\/span>
\n– Oracle EBS E\u011fitimleri<\/span>
\n– Oracle VM Server E\u011fitimleri<\/span>
\n– Weblogic E\u011fitimleri<\/span>
\n– Oracle EPPM E\u011fitimleri<\/span>
\n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Merhaba Arkada\u015flar, Bu yaz\u0131mda SQL Server AlwaysOn u anlatmaya devam edece\u011fim. Bu yaz\u0131mda Bir \u00f6nceki yaz\u0131lar\u0131m\u0131n devam\u0131 niteli\u011findedir.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,23],"tags":[108,460,508,614,1000,1031,1515,1577,1583,1594,1601,1618,1619,1632,1647,1653],"class_list":["post-5071","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-alwayson","tag-database-high-availability","tag-deveci","tag-failover","tag-log-shipping","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-2008-log-shipping","tag-sql-server-2012-alwayson","tag-sql-server-alwayson","tag-sql-server-alwayson-kurulumu","tag-sql-server-disaster-recovery","tag-sql-server-high-availability","tag-sql-server-log-shipping"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=5071"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5071\/revisions"}],"predecessor-version":[{"id":5761,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5071\/revisions\/5761"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=5071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=5071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=5071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}