{"id":2880,"date":"2013-02-05T07:41:35","date_gmt":"2013-02-05T07:41:35","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=2880"},"modified":"2019-02-28T08:53:19","modified_gmt":"2019-02-28T08:53:19","slug":"sql-server-2008-database-mirroring-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-2008-database-mirroring-2\/","title":{"rendered":"SQL Server 2008 Database Mirroring -2"},"content":{"rendered":"

Merhaba,<\/p>\n

<\/div>\n
Bu makalemde bir \u00f6nceki makalede giri\u015fini yapt\u0131\u011f\u0131m Database Mirroring konusuna devam edip Database Mirroring teknolojisinin ger\u00e7eklenmesini SQL Server 2008 de \u00a0uygulamal\u0131 olarak anlataca\u011f\u0131m.<\/div>\n
<\/div>\n
<\/div>\n
\"Mirroring\"<\/a><\/div>\n
<\/div>\n
<\/div>\n
\n

 <\/p>\n\n

3.Database Mirroring Konfig\u00fcrasyonu ve Ger\u00e7eklenmesi<\/strong><\/p>\n

Database Mirroring uygulamas\u0131n\u0131 birden fazla sunucu bilgisayar\u0131m olmad\u0131\u011f\u0131 i\u00e7in kendi local bilgisayar\u0131mda ger\u00e7ekleyece\u011fim. E\u011fer sizin test edebilece\u011finiz network konfig\u00fcrasyonu d\u00fczg\u00fcn olan ortamlar\u0131n\u0131z var ise birden fazla sunucuda \u00e7al\u0131\u015fan SQL Serverlar \u00fczerinde bu denemeyi yapabilirsiniz.<\/p>\n

Fakat e\u011fer benim gibi tek bir makinede bulunan 2 veya 3 SQL Server \u00fczerinde bu denemeyi yap\u0131yorsan\u0131z mutlak s\u00fcrette konfig\u00fcrasyonu yaparken Network portlar\u0131n\u0131 farkl\u0131 verin yoksa hata al\u0131rs\u0131n\u0131z. Local bilgisayar\u0131m da Windows -7 x86 i\u015fletim sistemi ve SQL Server 2008 Enterprise R2 versiyonunda 3 adet instance bulunmaktad\u0131r.<\/p>\n

Bu instancelar\u0131n adlar\u0131 Default \u0130nstance MSSQLSERVER , MYTESTINSTANCE ve DEVINSTANCE \u015feklindedir. Bu Instance lar\u0131n Mirroring olay\u0131ndaki Rolleri a\u015fa\u011f\u0131daki gibidir.<\/p>\n

Principal Server:\u00a0<\/strong>MSSQLSERVER<\/p>\n

Mirror Server:\u00a0<\/strong>MYTESTINSTANCE<\/p>\n

Witness Server:\u00a0<\/strong>DEVINSTANCE<\/p>\n

\u015eimdi \u00f6rnek bir senaryo \u00fczerinden veritaban\u0131 olu\u015ftururarak bu veritaban\u0131nda y\u00fck olu\u015fturuyorum. B\u00f6ylece elimde Mirroring i anlatan \u00f6rnek bir database olu\u015facakt\u0131r.<\/p>\n

A\u015fa\u011f\u0131daki kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m zaman Principal olarak d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm database de TestDatabase ad\u0131nda bir database ve testtable ad\u0131nda bir tablo create edilecektir.<\/p>\n

use master\r\ngo\r\ncreate database TestDatabase\r\ngo\r\n------------------------------\r\nuse TestDatabase\r\ncreate table testtable(\r\ncol1 int identity(1,1) not null,\r\ncol2 datetime null\r\n)\r\n-----------------------------------------------\r\n-----------------------------------------------\r\nuse TestDatabase\r\nalter table testtable add constraint DF_testtable_col2 default (getdate()) for col2\r\ngo\r\n-----------------------------------------------\r\n\r\n\"1\"<\/a><\/pre>\n
Bu database de y\u00fck olu\u015fmas\u0131 a\u00e7\u0131s\u0131ndan testtable tablosuna a\u015fa\u011f\u0131daki T-sql koduyla binlerce kay\u0131t insert ediyorum.<\/p>\n
\u00a0\r\n\r\nset nocount on\r\ngo\r\n\r\nwhile 1=1\r\nbegin\r\n     insert testtable values(default)\r\n     waitfor delay '00:00:01'\r\nend<\/pre>\n
\u0130lk a\u015famada database e 10000 den fazla kay\u0131t insert ettim. Database mirroring yapabilmem i\u00e7in Veritaban\u0131m\u0131n Recovery modeli Full modda olmal\u0131d\u0131r. Simple yada Bulk-Logged model Mirroring i desteklemez.<\/p>\n
Mirroring olay\u0131 i\u00e7in database anlam\u0131nda gereken kurallar teorik olarak a\u015fa\u011f\u0131daki gibidir.<\/p>\n
1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Mirroring yap\u0131lacak database Full Recovery Model olmal\u0131<\/p>\n
2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Her iki SQL Server \u0131 \u00c7al\u0131\u015ft\u0131ran Service Account \u0131n\u0131n ayn\u0131 olmal\u0131<\/p>\n
3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Principal database in ismi ile Mirror database in ismi ayn\u0131 olmal\u0131.<\/p>\n
Mirroring olay\u0131n\u0131n ad\u0131mlar\u0131 teorik olarak a\u015fa\u011f\u0131daki gibidir.<\/p>\n
1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Principal Server da kaynak veritaban\u0131n\u0131n Full Backup \u0131 al\u0131n\u0131r.<\/p>\n
2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Al\u0131nan Backup Mirror Server \u00fczerindeki Instance a\u00a0Restore With NoRecovery<\/em><\/strong>\u00a0Modda Ayn\u0131 isimde Restore edilir.<\/p>\n
3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Principal Server da Endpoint olu\u015fturarak Mirroring konfig\u00fcrasyonuna ba\u015fla.<\/p>\n
4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Mirroring konfig\u00fcrasyonunda son ad\u0131mdan \u00f6nce Principal database in Transaction Log backup \u0131n\u0131 al.<\/p>\n
5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Al\u0131nan Transaction log u Mirror Server \u00fczerindeki Instance a\u00a0Restore With NoRecovery<\/em><\/strong>\u00a0Modda Restore edilir.<\/p>\n
6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Mirroring Konfig\u00fcrasyonu tamamlanarak\u00a0Start Mirroring<\/em><\/strong>\u00a0denilir.<\/p>\n
Yukar\u0131da belirtti\u011fim kurallar\u0131n ad\u0131mlar\u0131 a\u015fa\u011f\u0131da SQL Server 2008 Management Studio \u00fczerinde ekran g\u00f6r\u00fcnt\u00fcs\u00fc vererek bu ad\u0131mlar\u0131 teyit ediyorum.<\/p>\n
1. A\u015fa\u011f\u0131daki resimdeki gibi veritaban\u0131n\u0131n Recovery modelini ilgili database e sa\u011f t\u0131klay\u0131p Properties men\u00fcs\u00fcnde Options Sekmesinde Full oldu\u011funu teyit ediyorum.<\/p>\n
\"2\"<\/a><\/p>\n
2. Local bilgisayar\u0131mda SQL Server Configuration Manager dan \u00fc\u00e7 SQL Server Instance s\u0131n\u0131 \u00e7al\u0131\u015ft\u0131ran Service account \u0131n\u0131n ayn\u0131 oldu\u011funu teyit ediyorum.<\/p>\n
\"3\"<\/a><\/p>\n
\u015eimdide Mirroring ad\u0131mlar\u0131n\u0131 uygulamaya koyup bunlar\u0131n ekran g\u00f6r\u00fcnt\u00fclerini vererek daha iyi anla\u015f\u0131lmas\u0131n\u0131 sa\u011flamaya \u00e7al\u0131\u015faca\u011f\u0131m.<\/p>\n
1.A\u015fa\u011f\u0131daki gibi TestDatabase inin Full backup \u0131n\u0131 s\u0131ras\u0131yla ekran g\u00f6r\u00fcnt\u00fclerinde oldu\u011fu gibi al\u0131yorum.<\/p>\n
\"4\"<\/a><\/p>\n
\"5\"<\/a><\/p>\n
\"6\"<\/a><\/p>\n
2.Bu ad\u0131mda ise Principal Server dan al\u0131nan Full Backup \u0131 Mirror Server da Restore ediyorum. Fakat Restore ederken\u00a0Restore With NORECOVERY<\/em><\/strong>\u00a0modda olmas\u0131na dikkat etmelisiniz.<\/p>\n
\"7\"<\/a><\/p>\n
\"8\"<\/a><\/p>\n
\"9\"<\/a><\/p>\n
\"10\"<\/a><\/p>\n
3.\u015eimdi Database mirroring konfig\u00fcrasyonunu yapal\u0131m. Bu ad\u0131mda a\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fclerindeki ad\u0131mlar\u0131 eksiksiz yapman\u0131z gerekmektedir.<\/p>\n
\"11\"<\/a><\/p>\n
\"12\"<\/a><\/p>\n
Bu ad\u0131mda isterseniz witness se\u00e7meden devam edebilirsiniz. Bu durumda Rol de\u011fi\u015fikli\u011fine ihtiya\u00e7 duyuldu\u011funda bunu siz ger\u00e7ekle\u015ftirmek zorundas\u0131n\u0131z.<\/p>\n
\"13\"<\/a><\/p>\n
\"14\"<\/a><\/p>\n
Bu ad\u0131mda Principal, Mirror ve Witness Database leri ayn\u0131 sunucuda oldu\u011fu i\u00e7in Portlar farkl\u0131 olmal\u0131d\u0131r. Zaten Management Studio default olarak ayn\u0131 sunucuda oldu\u011fu i\u00e7in portu farkl\u0131 olarak al\u0131yor.<\/p>\n
\"15\"<\/a><\/p>\n
\"16\"<\/a><\/p>\n
\"17\"<\/a><\/p>\n
Bu ad\u0131mda T\u00fcm SQL Instance lar\u0131n\u0131n Service account \u0131 ayn\u0131 oldu\u011fu i\u00e7in girmeye gerek yok.<\/p>\n
\"18\"<\/a><\/p>\n
Ayr\u0131ca Service Account lar\u0131n\u0131n Endpoint ler \u00fczerinde \u00e7al\u0131\u015fabilmesi i\u00e7in Service Hesab\u0131na Connect yetkisi vermeliyiz. A\u015fa\u011f\u0131da NT AUTHORITY\\SYSTEM Login ine Connect hakk\u0131 verip yukar\u0131daki ad\u0131m\u0131 bundan sonra ge\u00e7iyoruz.<\/p>\n
\"21\"<\/a><\/p>\n
\"19\"<\/a><\/p>\n
Bu ad\u0131mda Close deyip devam etmeden \u00f6nce 4 ve 5.Ad\u0131mlar\u0131 ger\u00e7ekle\u015ftiriyoruz. 4 ve 5.ad\u0131mlardan sonra Close\u00a0deyip Mirroring in son ad\u0131m\u0131na ge\u00e7iyoruz.<\/p>\n
\"20\"<\/a><\/p>\n
4. \u00a0 \u00a0 \u00a0Bu ad\u0131mda Mirroring tam ba\u015flamadan \u00f6nce son defa Principal database inin Transaction Log backup \u0131 al\u0131n\u0131r .<\/p>\n
\"23\"<\/a><\/p>\n
\"24\"<\/a><\/p>\n
5.Bu ad\u0131mda Principal database den al\u0131nan Transaction Log Backup Mirror database inin \u00fczerine\u00a0Restore With NoRecovery<\/em><\/strong>\u00a0olarak Restore edilir.<\/p>\n
\"25\"<\/a><\/p>\n
\"26\"<\/a><\/p>\n
6.Bu ad\u0131mda 3.Ad\u0131m\u0131n sonunda gelen ekrandaki Close Butonuna bas\u0131l\u0131r ve a\u015fa\u011f\u0131daki gibi Mirroring in son ad\u0131m\u0131 gelir.<\/p>\n
\"22\"<\/a><\/p>\n
Yukardaki ekranda Start Mirroring butonuna bas\u0131l\u0131r ve Mirroring e\u011fer do\u011fru konfig\u00fcre edilmi\u015fse a\u015fa\u011f\u0131daki gibi Senkron olmu\u015f bir \u015fekilde \u00e7al\u0131\u015f\u0131r.<\/p>\n
\"27\"<\/a><\/p>\n
B\u00f6ylece bu makaleninde sonuna gelmi\u015f bulunmaktay\u0131m. Bir sonraki makalede bu konuya devam edip Mirroring Testleri ve Mirroring Monitor yap\u0131p bu konuya son verece\u011fim.<\/p>\n
Esen Kal\u0131n…<\/p>\n\n
 <\/p>\n<\/div>\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, Bu makalemde bir \u00f6nceki makalede giri\u015fini yapt\u0131\u011f\u0131m Database Mirroring konusuna devam edip Database Mirroring teknolojisinin ger\u00e7eklenmesini SQL Server 2008 de \u00a0uygulamal\u0131 olarak anlataca\u011f\u0131m.<\/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":[460,466,508,717,1031,1049,1515,1577,1583,1595,1630,1647,1658],"class_list":["post-2880","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-database-high-availability","tag-database-mirroring","tag-deveci","tag-high-availability","tag-mehmet-salih-deveci","tag-mirroring","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-2008-mirroring","tag-sql-server-database-mirroring","tag-sql-server-high-availability","tag-sql-server-mirroring"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2880","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=2880"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2880\/revisions"}],"predecessor-version":[{"id":5899,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2880\/revisions\/5899"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=2880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=2880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=2880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}