{"id":4495,"date":"2026-06-26T07:00:00","date_gmt":"2026-06-26T04:00:00","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=4495"},"modified":"2026-06-26T17:20:01","modified_gmt":"2026-06-26T14:20:01","slug":"sql-server-tde-hatasi-cannot-find-server-asymmetric-key-thumbprint-cozum-ve-kurtarma-rehberi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-server-tde-hatasi-cannot-find-server-asymmetric-key-thumbprint-cozum-ve-kurtarma-rehberi\/","title":{"rendered":"SQL Server TDE &#8211; Kurtarma Rehberi (V7.1)"},"content":{"rendered":"<h1><span class=\"\">\ud83d\udd10 SQL Server TDE Sald\u0131r\u0131s\u0131na U\u011frad\u0131n\u0131z m\u0131? \u0130\u015fte Ad\u0131m Ad\u0131m Kurtarma Rehberi<\/span><\/h1>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Fidye yaz\u0131l\u0131m\u0131 sald\u0131r\u0131s\u0131 sonras\u0131 SQL Server&#8217;\u0131n\u0131z TDE ile \u015fifrelendi mi?<\/span><\/strong><br \/><strong><span class=\"\">Verilerinize eri\u015fiminiz kesildi mi? Panik yapmay\u0131n. Bu rehber size nas\u0131l kurtulaca\u011f\u0131n\u0131z\u0131 anlat\u0131yor.<\/span><\/strong><\/p>\n<hr \/>\n<h2><span class=\"\">\ud83d\udccc \u0130\u00e7indekiler<\/span><\/h2>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udea8 Sald\u0131r\u0131y\u0131 Tespit Edin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u26a0\ufe0f SQL Server S\u00fcr\u00fcm\u00fcne Dikkat!<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udea8 Sald\u0131r\u0131 Nas\u0131l Ger\u00e7ekle\u015fir?<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u274c YAPILMAMASI GEREKENLER (KR\u0130T\u0130K!)<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u2705 YAPILMASI GEREKENLER (KURTARMA REHBER\u0130)<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83c\udd98 Sertifika Kayb\u0131 Durumu<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udccb \u00d6nleyici Tedbirler<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udee0\ufe0f Ad\u0131m Ad\u0131m Kurtarma Plan\u0131<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u23f1\ufe0f Ne Kadar S\u00fcrer?<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udd34 Ne Zaman Umutsuzlu\u011fa Kap\u0131lmal\u0131s\u0131n\u0131z?<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83c\udfaf Kurtarma Kontrol Listesi<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83c\udfe0 &#8220;Evin Sahibiyim Ama Tapum Yok&#8221;<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udca1 As\u0131l Sorun Ne? &#8211; Dengeli Bir Bak\u0131\u015f<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udce2 Son S\u00f6z: Umut Var!<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udee0\ufe0f Otomatik Kurtarma Arac\u0131<\/span><\/p>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span class=\"\">\ud83d\udea8 Sald\u0131r\u0131y\u0131 Tespit Edin<\/span><\/h2>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">SQL Server&#8217;\u0131n\u0131zda a\u015fa\u011f\u0131daki belirtiler varsa TDE sald\u0131r\u0131s\u0131na u\u011fram\u0131\u015f olabilirsiniz:<\/span><\/p>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Belirti<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">\u2705 Veritabanlar\u0131n\u0131za eri\u015femiyorsunuz<\/span><\/td>\n<td><span class=\"\">Uygulamalar \u00e7al\u0131\u015fm\u0131yor, ba\u011flant\u0131 hatalar\u0131 al\u0131n\u0131yor<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705 &#8220;TDE Aktif&#8221; uyar\u0131s\u0131 al\u0131yorsunuz<\/span><\/td>\n<td><span class=\"\">Yard\u0131mc\u0131 yaz\u0131l\u0131m bunu tespit eder<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705 Sertifika listesinde tan\u0131mad\u0131\u011f\u0131n\u0131z isimler var<\/span><\/td>\n<td><span class=\"\">Yard\u0131mc\u0131 yaz\u0131l\u0131m bunlar\u0131 listeler<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705 &#8220;Fidye notu&#8221; b\u0131rak\u0131lm\u0131\u015f olabilir<\/span><\/td>\n<td><code>C:\\<\/code><span class=\"\">\u00a0veya masa\u00fcst\u00fcnde not dosyas\u0131<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705 SQL Server loglar\u0131nda anormal aktivite<\/span><\/td>\n<td><span class=\"\">Yard\u0131mc\u0131 yaz\u0131l\u0131m ile kontrol edin<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udca1\u00a0<\/span><strong><span class=\"\">Kritik tespitler, geli\u015ftirdi\u011fimiz yard\u0131mc\u0131 yaz\u0131l\u0131m taraf\u0131ndan otomatik olarak yap\u0131lmaktad\u0131r.<\/span><\/strong><\/p>\n<\/blockquote>\n<hr \/>\n<h2><span class=\"\">\u26a0\ufe0f SQL Server S\u00fcr\u00fcm\u00fcne Dikkat!<\/span><\/h2>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">SQL Server S\u00fcr\u00fcm\u00fc<\/span><\/th>\n<th><span class=\"\">TDE Deste\u011fi<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">Enterprise<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 Destekler<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Standard<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 Destekler<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Developer<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 Destekler<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Express<\/span><\/strong><\/td>\n<td><span class=\"\">\u274c\u00a0<\/span><strong><span class=\"\">DESTEKLEMEZ!<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Web<\/span><\/strong><\/td>\n<td><span class=\"\">\u274c Desteklemez<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">\u00d6nemli:<\/span><\/strong><span class=\"\">\u00a0E\u011fer SQL Server\u00a0<\/span><strong><span class=\"\">Express<\/span><\/strong><span class=\"\">\u00a0s\u00fcr\u00fcm\u00fc kullan\u0131yorsan\u0131z, TDE sald\u0131r\u0131s\u0131\u00a0<\/span><strong><span class=\"\">m\u00fcmk\u00fcn de\u011fildir<\/span><\/strong><span class=\"\">. Bu durumda sald\u0131r\u0131 farkl\u0131 bir y\u00f6ntemle (dosya \u015fifreleme, Always Encrypted vb.) yap\u0131lm\u0131\u015f olabilir.<\/span><\/p>\n<\/blockquote>\n<hr \/>\n<h2><span class=\"\">\ud83d\udea8 Sald\u0131r\u0131 Nas\u0131l Ger\u00e7ekle\u015fir?<\/span><\/h2>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Ad\u0131m<\/span><\/th>\n<th><span class=\"\">Yapt\u0131\u011f\u0131 \u0130\u015flem<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">1<\/span><\/strong><\/td>\n<td><span class=\"\">Sald\u0131rgan sisteme eri\u015fir (zafiyet, zay\u0131f \u015fifre, vb.)<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">2<\/span><\/strong><\/td>\n<td><span class=\"\">TDE&#8217;yi aktif eder (kendi sertifikas\u0131n\u0131 olu\u015fturarak)<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">3<\/span><\/strong><\/td>\n<td><span class=\"\">T\u00fcm veritabanlar\u0131n\u0131 \u015fifreler<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">4<\/span><\/strong><\/td>\n<td><span class=\"\">Sertifikay\u0131 sistemden siler veya yan\u0131na al\u0131r<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">5<\/span><\/strong><\/td>\n<td><span class=\"\">Fidye talebinde bulunur (sertifika kar\u015f\u0131l\u0131\u011f\u0131nda)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\u274c YAPILMAMASI GEREKENLER (KR\u0130T\u0130K!)<\/span><\/h2>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Yap\u0131lmamas\u0131 Gereken<\/span><\/th>\n<th><span class=\"\">Sonucu<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">SQL Server&#8217;\u0131 yeniden ba\u015flatmak<\/span><\/strong><\/td>\n<td><span class=\"\">\ud83d\udc80 Sertifika cache&#8217;ten u\u00e7ar, Bu y\u00f6ntem ile kurtarma imkans\u0131z! (Kalan ihtimal adli\/forensic yollar)<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Bilgisayar\u0131 yeniden ba\u015flatmak<\/span><\/strong><\/td>\n<td><span class=\"\">\ud83d\udc80 Ayn\u0131 sonu\u00e7, veriler kaybolur!<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Panik yapmak<\/span><\/strong><\/td>\n<td><span class=\"\">\ud83d\ude30 Mant\u0131kl\u0131 d\u00fc\u015f\u00fcnemez, hata yapars\u0131n\u0131z<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Fidye \u00f6demek<\/span><\/strong><\/td>\n<td><span class=\"\">\ud83d\udcb0 \u00d6nerilmez, tekrar sald\u0131r\u0131r, yasal sorunlar<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Yedek almadan i\u015flem yapmak<\/span><\/strong><\/td>\n<td><span class=\"\">\u26a0\ufe0f Mevcut durumu daha da k\u00f6t\u00fcle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">SQL Server&#8217;\u0131 durdurmak<\/span><\/strong><\/td>\n<td><span class=\"\">\ud83d\udc80 Sertifika cache&#8217;ten u\u00e7ar<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\u2705 YAPILMASI GEREKENLER (KURTARMA REHBER\u0130)<\/span><\/h2>\n<h3><span class=\"\">1\ufe0f\u20e3 \u00d6NCE DURUM TESP\u0130T\u0130 YAPIN<\/span><\/h3>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Yard\u0131mc\u0131 yaz\u0131l\u0131m\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">TDE durumunu kontrol edin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Sertifika varl\u0131\u011f\u0131n\u0131 kontrol edin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Sald\u0131r\u0131 durumunu analiz edin<\/span><\/p>\n<\/li>\n<\/ul>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udca1\u00a0<\/span><strong><span class=\"\">Yard\u0131mc\u0131 yaz\u0131l\u0131m<\/span><\/strong><span class=\"\">\u00a0sizlere bu konuda detayl\u0131 rapor sunacakt\u0131r.<\/span><\/p>\n<\/blockquote>\n<h3><span class=\"\">2\ufe0f\u20e3 ASLA RESTART YAPMAYIN! \ud83d\udd34<\/span><\/h3>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">En kritik kural:<\/span><\/strong><span class=\"\">\u00a0SQL Server veya bilgisayar restart edilirse, sertifika cache&#8217;ten u\u00e7ar. Restart sonras\u0131 kurtarma\u00a0<\/span><strong><span class=\"\">M\u00dcMK\u00dcN DE\u011e\u0130LD\u0130R!<\/span><\/strong><\/p>\n<\/blockquote>\n<h3><span class=\"\">3\ufe0f\u20e3 YAZILIM \u0130LE M\u00dcDAHALE ED\u0130N<\/span><\/h3>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">SQL Server\u00a0<\/span><strong><span class=\"\">\u00e7al\u0131\u015f\u0131rken<\/span><\/strong><span class=\"\">\u00a0sertifikalar\u0131 yedekleyin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">TDE&#8217;yi devre d\u0131\u015f\u0131 b\u0131rak\u0131n (decryption)<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u0130\u015flem bitene kadar bekleyin (veritaban\u0131 boyutuna g\u00f6re saatler s\u00fcrebilir)<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u015eifre \u00e7\u00f6z\u00fcld\u00fckten sonra yedek al\u0131n<\/span><\/p>\n<\/li>\n<\/ul>\n<h3><span class=\"\">4\ufe0f\u20e3 KURTARMA SONRASI YAPILACAKLAR<\/span><\/h3>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Al\u0131nan yede\u011fi farkl\u0131 bir sunucuda test edin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc kontrol edin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">G\u00fcvenlik \u00f6nlemlerini g\u00f6zden ge\u00e7irin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u015eifreleri de\u011fi\u015ftirin<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Sald\u0131r\u0131 kayna\u011f\u0131n\u0131 tespit edin<\/span><\/p>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span class=\"\">\ud83c\udd98 Sertifika Kayb\u0131 Durumu<\/span><\/h2>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">E\u011fer sertifika sistemde\u00a0<\/span><strong><span class=\"\">YOK<\/span><\/strong><span class=\"\">\u00a0ise:<\/span><\/p>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Durum<\/span><\/th>\n<th><span class=\"\">\u00c7\u00f6z\u00fcm<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">Sertifika yede\u011fi var<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 Yedekten sertifikay\u0131 y\u00fckleyin<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Sertifika yede\u011fi yok<\/span><\/strong><\/td>\n<td><span class=\"\">\u274c <strong>BU Y\u00d6NTEM \u0130LE<\/strong> <\/span><strong><span class=\"\">KURTARMA \u0130MKANSIZ! (Kalan ihtimal adli\/forensic yollar)<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Sald\u0131r\u0131 \u00f6ncesi yedek var<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 Yedekten geri y\u00fckleyin<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Hi\u00e7 yedek yok<\/span><\/strong><\/td>\n<td><span class=\"\">\ud83d\udc80\u00a0<\/span><strong><span class=\"\">VER\u0130 KAYBI KA\u00c7INILMAZ!<\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\ud83d\udccb \u00d6nleyici Tedbirler<\/span><\/h2>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Tedbir<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">D\u00fczenli Yedek<\/span><\/strong><\/td>\n<td><span class=\"\">G\u00fcnl\u00fck, haftal\u0131k, ayl\u0131k yedek stratejisi<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Sertifika Yede\u011fi<\/span><\/strong><\/td>\n<td><span class=\"\">TDE sertifikalar\u0131n\u0131 g\u00fcvenli yerde saklay\u0131n<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">G\u00fc\u00e7l\u00fc \u015eifreler<\/span><\/strong><\/td>\n<td><span class=\"\">SQL Server ve Windows hesaplar\u0131<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Yetki Kontrol\u00fc<\/span><\/strong><\/td>\n<td><span class=\"\">Minimum yetki prensibi<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">G\u00fcncellemeler<\/span><\/strong><\/td>\n<td><span class=\"\">SQL Server ve Windows g\u00fcncellemeleri<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Log Takibi<\/span><\/strong><\/td>\n<td><span class=\"\">Anormal aktiviteleri tespit edin<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">G\u00fcvenlik Duvar\u0131<\/span><\/strong><\/td>\n<td><span class=\"\">Sadece gerekli portlar\u0131 a\u00e7\u0131n<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">SQL Agent Job<\/span><\/strong><\/td>\n<td><span class=\"\">TDE aktifli\u011fini otomatik izleyin<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\ud83d\udee0\ufe0f Ad\u0131m Ad\u0131m Kurtarma Plan\u0131<\/span><\/h2>\n<h3><span class=\"\">1. Panik Yapmay\u0131n, Durumu Tespit Edin<\/span><\/h3>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">SQL Server&#8217;\u0131\u00a0<\/span><strong><span class=\"\">KAPATMAYIN!<\/span><\/strong><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Hemen yaz\u0131l\u0131m\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">TDE durumunu kontrol edin<\/span><\/p>\n<\/li>\n<\/ul>\n<h3><span class=\"\">2. TDE&#8217;yi Kapatmaya Ba\u015flay\u0131n (UMUT I\u015eI\u011eI!)<\/span><\/h3>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Bu ad\u0131m \u00c7OK \u00d6NEML\u0130:<\/span><\/strong><span class=\"\">\u00a0TDE&#8217;yi kapatmak i\u00e7in sald\u0131rgan\u0131n \u015fifresine ihtiyac\u0131n\u0131z YOK! (Sistem hen\u00fcz Aktif ise)<\/span><\/p>\n<\/blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u23f3 Bu i\u015flem arka planda ba\u015flar. Veritaban\u0131 boyutuna g\u00f6re\u00a0<\/span><strong><span class=\"\">1 saat ile 1 HAFTA<\/span><\/strong><span class=\"\">\u00a0aras\u0131 s\u00fcrebilir!<\/span><\/p>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udca1\u00a0<\/span><strong><span class=\"\">Yaz\u0131l\u0131mda sizlere yard\u0131mc\u0131 ara\u00e7 sunulmu\u015ftur.<\/span><\/strong><\/p>\n<h3><span class=\"\">3. \u0130lerlemeyi Takip Edin<\/span><\/h3>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Beklenen Durumlar:<\/span><\/strong><\/p>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">G\u00f6rd\u00fc\u011f\u00fcn\u00fcz Durum<\/span><\/th>\n<th><span class=\"\">Anlam\u0131<\/span><\/th>\n<th><span class=\"\">Ne Yapmal\u0131s\u0131n\u0131z?<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">\u015eifreleme anahtar\u0131 yok<\/span><\/td>\n<td><span class=\"\">TDE zaten kapal\u0131<\/span><\/td>\n<td><span class=\"\">\u2705 G\u00fcvendesiniz<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u015eifre \u00e7\u00f6z\u00fcl\u00fcyor&#8230; %X<\/span><\/td>\n<td><span class=\"\">\u23f3 KURTARMA \u00c7ALI\u015eIYOR!<\/span><\/td>\n<td><span class=\"\">Bekleyin, ilerlemeyi izleyin<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u015eifrelenmi\u015f<\/span><\/td>\n<td><span class=\"\">Sald\u0131r\u0131 devam ediyor<\/span><\/td>\n<td><span class=\"\">TDE kapatma komutunu kontrol edin<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u015eifrelenmemi\u015f<\/span><\/td>\n<td><span class=\"\">\u2705 KURTARMA TAMAMLANDI!<\/span><\/td>\n<td><span class=\"\">Yedek al\u0131n<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3><span class=\"\">4. \u015eifre \u00c7\u00f6zme Tamamland\u0131\u011f\u0131nda Ne Olur?<\/span><\/h3>\n<p>\u2705 Durum: &#8216;\u015eifrelenmemi\u015f&#8217;<br \/>\u2705 \u0130lerleme: 100%<\/p>\n<h3><span class=\"\">5. KURTARMA SONRASI YAPILACAKLAR<\/span><\/h3>\n<h4><span class=\"\">A. HEMEN YEDEK ALIN!<\/span><\/h4>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udca1\u00a0<\/span><strong><span class=\"\">Yaz\u0131l\u0131m size yedek almay\u0131 hat\u0131rlatacakt\u0131r.<\/span><\/strong><\/p>\n<\/blockquote>\n<h4><span class=\"\">B. SALDIRIYA U\u011eRAMI\u015e S\u0130STEM\u0130 ASLA KULLANMAYIN!<\/span><\/h4>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u26a0\ufe0f\u00a0<\/span><strong><span class=\"\">KR\u0130T\u0130K UYARI:<\/span><\/strong><span class=\"\">\u00a0Sald\u0131r\u0131ya u\u011fram\u0131\u015f sistemde, sald\u0131rgan arka kap\u0131 (backdoor) b\u0131rakm\u0131\u015f olabilir. Bu sistemi asla g\u00fcvenli olarak kabul etmeyin!<\/span><\/p>\n<\/blockquote>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Yapman\u0131z gerekenler:<\/span><\/strong><\/p>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__horizontal-gutter\">\u00a0<\/div>\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Ad\u0131m<\/span><\/th>\n<th><span class=\"\">Yap\u0131lacak \u0130\u015flem<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">\ud83d\udda5\ufe0f<\/span><\/td>\n<td><span class=\"\">Yeni bir sunucu kurun (temiz i\u015fletim sistemi)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\ud83d\udd27<\/span><\/td>\n<td><span class=\"\">SQL Server&#8217;\u0131 yeniden kurun (g\u00fcncel s\u00fcr\u00fcm)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\ud83d\udce6<\/span><\/td>\n<td><span class=\"\">\u015eifresiz yede\u011fi yeni sunucuya geri y\u00fckleyin<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\ud83d\udd12<\/span><\/td>\n<td><span class=\"\">Yeni g\u00fc\u00e7l\u00fc parolalar belirleyin<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\ud83d\udee1\ufe0f<\/span><\/td>\n<td><span class=\"\">G\u00fcvenlik \u00f6nlemlerini art\u0131r\u0131n (firewall, g\u00fcncellemeler, vb.)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\ud83d\udcdd<\/span><\/td>\n<td><span class=\"\">T\u00fcm loglar\u0131 inceleyin (sald\u0131r\u0131 kayna\u011f\u0131n\u0131 tespit i\u00e7in)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\u23f1\ufe0f Ne Kadar S\u00fcrer?<\/span><\/h2>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Veritaban\u0131 Boyutu<\/span><\/th>\n<th><span class=\"\">Tahmini \u015eifre \u00c7\u00f6zme S\u00fcresi<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">1 GB<\/span><\/td>\n<td><span class=\"\">1-5 dakika<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">10 GB<\/span><\/td>\n<td><span class=\"\">10-30 dakika<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">100 GB<\/span><\/td>\n<td><span class=\"\">1-4 saat<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">500 GB<\/span><\/td>\n<td><span class=\"\">6-24 saat<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">1 TB<\/span><\/td>\n<td><span class=\"\">1-3 g\u00fcn<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">5 TB+<\/span><\/td>\n<td><span class=\"\">3-7 g\u00fcn<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udccc\u00a0<\/span><strong><span class=\"\">NOT:<\/span><\/strong><span class=\"\">\u00a0Bu s\u00fcreler sunucu performans\u0131na, disk h\u0131z\u0131na ve CPU g\u00fcc\u00fcne g\u00f6re de\u011fi\u015fir.<\/span><\/p>\n<\/blockquote>\n<hr \/>\n<h2><span class=\"\">\ud83d\udd34 Ne Zaman Umutsuzlu\u011fa Kap\u0131lmal\u0131s\u0131n\u0131z?<\/span><\/h2>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">A\u015fa\u011f\u0131daki durumlarda kurtarma m\u00fcmk\u00fcn de\u011fildir:<\/span><\/p>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Durum<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">\u274c Sald\u0131rgan veritaban\u0131n\u0131 sildi<\/span><\/td>\n<td><code>.mdf\/.ldf<\/code><span class=\"\">\u00a0dosyalar\u0131 yok<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u274c Sald\u0131rgan TDE&#8217;yi kendi sunucusunda a\u00e7t\u0131<\/span><\/td>\n<td><span class=\"\">Sertifika sizin sisteminizde de\u011fil<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u274c Veritaban\u0131 dosyalar\u0131 \u015fifrelendi (dosya d\u00fczeyinde)<\/span><\/td>\n<td><span class=\"\">Windows EFS veya ba\u015fka bir \u015fifreleme<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u274c Sadece\u00a0<\/span><code>.bak<\/code><span class=\"\">\u00a0dosyas\u0131 var ve sertifika yede\u011fi yok<\/span><\/td>\n<td><span class=\"\">\u015eifreyi bilmiyorsan\u0131z \u201cBu y\u00f6ntemle kurtarma imk\u00e2ns\u0131z\u201d<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u274c SQL Server restart edildi<\/span><\/td>\n<td><span class=\"\">Sertifika cache&#8217;ten u\u00e7tu<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\ud83c\udfaf Kurtarma Kontrol Listesi<\/span><\/h2>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Durumu tespit et<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">SQL Server&#8217;\u0131 restart etme!<\/span><\/strong><span class=\"\">\u00a0\ud83d\udd34<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">TDE&#8217;yi kapat<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u0130lerlemeyi takip et<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u015eifre \u00e7\u00f6zme tamamlans\u0131n (1 saat &#8211; 1 hafta)<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u015eifresiz yede\u011fi al<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Yeni temiz sunucu kur<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Yede\u011fi yeni sunucuya geri y\u00fckle<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">G\u00fcvenlik \u00f6nlemlerini art\u0131r<\/span><\/p>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span class=\"\">\ud83c\udfe0 &#8220;Evin Sahibiyim Ama Tapum Yok&#8221;<\/span><\/h2>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Bir d\u00fc\u015f\u00fcn\u00fcn: Eviniz var, i\u00e7inde ya\u015f\u0131yorsunuz, her \u015feyiniz orada. Ama bir g\u00fcn tapunuz kayboluyor. Belediyeye gidiyorsunuz ve diyorsunuz ki:<\/span><\/p>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><em><span class=\"\">&#8220;Evin sahibi benim. \u0130\u015fte n\u00fcfus c\u00fczdan\u0131m, i\u015fte parmak izim, i\u015fte kom\u015fular\u0131m da beni tan\u0131yor. Bana yeni bir tapu verin.&#8221;<\/span><\/em><\/p>\n<\/blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Belediye size ne der?\u00a0<\/span><strong><span class=\"\">Tabii ki verir.<\/span><\/strong><span class=\"\">\u00a0Kim oldu\u011funuzu kan\u0131tlad\u0131\u011f\u0131n\u0131z s\u00fcrece, tapu yenilenir.<\/span><\/p>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Peki SQL Server&#8217;da ne oluyor?<\/span><\/strong><\/p>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Veritaban\u0131n\u0131z var, i\u00e7inde y\u0131llar\u0131n verisi. Ama TDE sertifikan\u0131z kayboluyor (sald\u0131r\u0131, format, yedek al\u0131nmamas\u0131&#8230;). Microsoft&#8217;a gidip diyorsunuz ki:<\/span><\/p>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><em><span class=\"\">&#8220;Veritaban\u0131n\u0131n sahibi benim. \u0130\u015fte Windows kullan\u0131c\u0131 hesab\u0131m, i\u015fte IP adresim, i\u015fte SQL Server loglar\u0131m, i\u015fte diskin fiziksel varl\u0131\u011f\u0131. Bana yeni bir sertifika verin.&#8221;<\/span><\/em><\/p>\n<\/blockquote>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Microsoft size ne der?<\/span><\/strong><\/p>\n<blockquote>\n<p class=\"ds-markdown-paragraph\">\u201cTDE mimarisi gere\u011fi \u00fcretici yeni sertifika olu\u015fturamaz; anahtar sahipli\u011fi tamamen sistem y\u00f6neticisindedir.\u201d<\/p>\n<\/blockquote>\n<h3><span class=\"\">\ud83e\udd2f \u0130\u015fte Sorun Tam Olarak Bu!<\/span><\/h3>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Ger\u00e7ek Hayat (Tapu)<\/span><\/th>\n<th><span class=\"\">SQL Server TDE (Sertifika)<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">\u00a0Devlet size <\/span><strong><span class=\"\">yeni tapu verir\u00a0 \u00a0<\/span><\/strong><\/td>\n<td><span class=\"\">\u00a0Microsoft size <\/span><strong><span class=\"\">yeni sertifika VERMEZ\u00a0 \u00a0<\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\ud83d\udca1 As\u0131l Sorun Ne? &#8211; Dengeli Bir Bak\u0131\u015f<\/span><\/h2>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Bu noktada\u00a0<\/span><strong><span class=\"\">tek tarafl\u0131 su\u00e7lama<\/span><\/strong><span class=\"\">\u00a0yapmak yerine, durumu\u00a0<\/span><strong><span class=\"\">t\u00fcm y\u00f6nleriyle<\/span><\/strong><span class=\"\">\u00a0de\u011ferlendirmek gerekiyor.<\/span><\/p>\n<h3><span class=\"\">\ud83d\udd34 S\u0130STEM SAH\u0130B\u0130N\u0130N SORUMLULUKLARI:<\/span><\/h3>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Sorumluluk<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">D\u00fczenli Yedek Alma<\/span><\/strong><\/td>\n<td><span class=\"\">Sald\u0131r\u0131 \u00f6ncesi yedekler hayat kurtar\u0131r<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">G\u00fcvenlik \u00d6nlemleri<\/span><\/strong><\/td>\n<td><span class=\"\">Firewall, g\u00fcncellemeler, g\u00fc\u00e7l\u00fc \u015fifreler<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Yetki Y\u00f6netimi<\/span><\/strong><\/td>\n<td><span class=\"\">Minimum yetki prensibi (Least Privilege)<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Sertifika Yedekleme<\/span><\/strong><\/td>\n<td><span class=\"\">TDE sertifikalar\u0131n\u0131 g\u00fcvenli yerde saklama<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Uzman Deste\u011fi Alma<\/span><\/strong><\/td>\n<td><span class=\"\">Profesyonel SQL Server dan\u0131\u015fmanlar\u0131 ile \u00e7al\u0131\u015fma<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3><span class=\"\">\ud83d\udd35 MICROSOFT&#8217;UN SORUMLULUKLARI:<\/span><\/h3>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Sorumluluk<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">TDE Tasar\u0131m\u0131<\/span><\/strong><\/td>\n<td><span class=\"\">Sertifika kayb\u0131nda kurtarma imkan\u0131 sunmamak<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Acil Durum Mekanizmas\u0131<\/span><\/strong><\/td>\n<td><span class=\"\">Sistem sahibine eri\u015fim hakk\u0131 tan\u0131mamak<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Destek Politikas\u0131<\/span><\/strong><\/td>\n<td><span class=\"\">&#8220;Sizin sorununuz&#8221; yakla\u015f\u0131m\u0131<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">G\u00fcvenlik A\u00e7\u0131\u011f\u0131<\/span><\/strong><\/td>\n<td><span class=\"\">Sysadmin&#8217;in TDE&#8217;yi a\u015fabilmesi<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3><span class=\"\">\ud83d\udfe2 UZMAN EK\u0130PLER\u0130N ROL\u00dc:<\/span><\/h3>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Rol<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">SQL Server Dan\u0131\u015fmanlar\u0131\u00a0\u00a0<\/span><\/strong><\/td>\n<td><span class=\"\">Do\u011fru yap\u0131land\u0131rma, yedekleme stratejileri<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Siber G\u00fcvenlik Uzmanlar\u0131\u00a0\u00a0<\/span><\/strong><\/td>\n<td><span class=\"\">Zafiyet tespiti, sald\u0131r\u0131 \u00f6nleme<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Veri Kurtarma Uzmanlar\u0131\u00a0\u00a0<\/span><\/strong><\/td>\n<td><span class=\"\">Acil durum m\u00fcdahalesi<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<h2><span class=\"\">\ud83d\udcca SONU\u00c7: K\u0130M NE YAPMALI?<\/span><\/h2>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<table>\n<thead>\n<tr>\n<th><span class=\"\">Taraf<\/span><\/th>\n<th><span class=\"\">Yapmas\u0131 Gereken<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong><span class=\"\">Sistem Sahibi<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 D\u00fczenli yedek almal\u0131, g\u00fcvenlik \u00f6nlemlerini almal\u0131, uzman destek almal\u0131<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Microsoft<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 Sertifika kayb\u0131nda kurtarma mekanizmas\u0131 sunmal\u0131<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong><span class=\"\">Uzman Ekipler<\/span><\/strong><\/td>\n<td><span class=\"\">\u2705 G\u00fcvenlik kontrolleri yapmal\u0131, dan\u0131\u015fmanl\u0131k vermeli<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<blockquote>\n<p class=\"ds-markdown-paragraph\">\u26a0\ufe0f <strong data-start=\"555\" data-end=\"563\">Not:<\/strong> Ticari yaz\u0131l\u0131m kullanmak, t\u00fcm teknik sorumlulu\u011fun yaz\u0131l\u0131m \u00fcreticisine ait oldu\u011fu anlam\u0131na gelmez. <span class=\"hover:entity-accent entity-underline inline cursor-pointer align-baseline\"><span class=\"whitespace-normal\">Microsoft SQL Server<\/span><\/span> y\u00f6netimi, yedekleme stratejileri ve g\u00fcvenlik \u00f6nlemleri sistem sahibinin sorumlulu\u011fundad\u0131r. \u00d6zellikle <strong data-start=\"801\" data-end=\"835\">Express s\u00fcr\u00fcm s\u0131n\u0131rlar\u0131n\u0131 a\u015fan<\/strong>, kritik veri bar\u0131nd\u0131ran veya operasyonel b\u00fcy\u00fckl\u00fc\u011f\u00fc artan yap\u0131larda, SQL altyap\u0131s\u0131n\u0131n uzman ki\u015filer taraf\u0131ndan kurulmas\u0131, d\u00fczenli olarak kontrol edilmesi ve g\u00fcvenlik yap\u0131land\u0131rmalar\u0131n\u0131n g\u00f6zden ge\u00e7irilmesi b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Ancak buna ra\u011fmen \u00fcreticilerin de, d\u00fc\u015f\u00fck teknik bilgiye sahip kullan\u0131c\u0131 kitlesinin olu\u015fturdu\u011fu riskleri g\u00f6z \u00f6n\u00fcnde bulundurarak daha koruyucu ve destekleyici yakla\u015f\u0131mlar geli\u015ftirmesi gerekir.<\/p>\n<\/blockquote>\n<h2><span class=\"\">\ud83d\udce2 Son S\u00f6z: Umut Var!<\/span><\/h2>\n<blockquote>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udcaa\u00a0<\/span><strong><span class=\"\">Bu rehber, sald\u0131r\u0131ya u\u011frayan ve yard\u0131ma ihtiyac\u0131 olanlar i\u00e7in haz\u0131rlanm\u0131\u015ft\u0131r.<\/span><\/strong><\/p>\n<\/blockquote>\n<ul>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u2705 TDE&#8217;yi kapatmak i\u00e7in \u015fifreye ihtiyac\u0131n\u0131z yoktur!<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u2705 &#8220;\u015eifreleme anahtar\u0131 yok&#8221; veya &#8220;\u015eifrelenmemi\u015f&#8221; g\u00f6rene kadar bekleyin. Bu bir UMUT demektir!<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\u2705\u00a0<\/span><strong><span class=\"\">Asla sald\u0131r\u0131ya u\u011fram\u0131\u015f sistemde devam etmeyin.<\/span><\/strong><span class=\"\">\u00a0Temiz bir sistemle yeniden ba\u015flay\u0131n.<\/span><\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udd34\u00a0<\/span><strong><span class=\"\">SQL RESTART = VER\u0130 KAYBI R\u0130SK\u0130!<\/span><\/strong><\/p>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span class=\"\">\ud83d\udee0\ufe0f Otomatik Kurtarma Arac\u0131<\/span><\/h2>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Bu i\u015flemleri otomatikle\u015ftiren bir ara\u00e7 geli\u015ftirdim:\u00a0<\/span><strong><span class=\"\">SQL TDE Kurtarma Asistan\u0131<\/span><\/strong><\/p>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\n<div class=\"ds-scroll-area__gutters\">\n<div class=\"ds-scroll-area__vertical-gutter\">\u00a0<\/div>\n<\/div>\n<table>\n<thead>\n<tr>\n<th><span class=\"\">\u00d6zellik<\/span><\/th>\n<th><span class=\"\">A\u00e7\u0131klama<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span class=\"\">\u2705<\/span><\/td>\n<td><span class=\"\">TDE durumunu listeler<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705<\/span><\/td>\n<td><span class=\"\">Tek t\u0131kla TDE&#8217;yi kapat\u0131r<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705<\/span><\/td>\n<td><span class=\"\">\u0130lerlemeyi canl\u0131 g\u00f6sterir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705<\/span><\/td>\n<td><span class=\"\">Sertifikalar\u0131 listeler<\/span><\/td>\n<\/tr>\n<tr>\n<td><span class=\"\">\u2705<\/span><\/td>\n<td><span class=\"\">Kurtarma sonras\u0131 yedek almay\u0131 hat\u0131rlat\u0131r<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">\ud83d\udce5\u00a0<\/span><strong><span class=\"\">Ara\u00e7 indirmek i\u00e7in a\u015fa\u011f\u0131daki linke t\u0131klay\u0131n.<\/span><\/strong><\/p>\n<h2><span class=\"\">\ud83d\udce2 V5 ve sonras\u0131 zamanl\u0131 g\u00f6rev ve otomatik sald\u0131r\u0131 an\u0131nda gizli yedekler al\u0131nmas\u0131 eklendi<\/span><\/h2>\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/1Ig13Btnk_qd645i-SxDmOdK3zPSSIWth\/view?usp=sharing\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1012\" src=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2015\/03\/indir.png\" alt=\"\" width=\"156\" height=\"43\" \/>\u00a0<\/a><\/p>\n<p>\ud83d\udee1\ufe0f TDE Kontrol ve G\u00fcvenlik Asistan\u0131 V6.1<\/p>\n<p>\u2705 OTOMAT\u0130K KORUMA (Se\u00e7im Kutusu ile aktif olur)<br \/>\u2022 5 dakikada bir sistem taramas\u0131<br \/>\u2022 TDE (Transparent Data Encryption) sald\u0131r\u0131s\u0131 an\u0131nda otomatik m\u00fcdahale<br \/>\u2022 Sald\u0131r\u0131 tespitinde an\u0131nda yedekleme<\/p>\n<p>\u2705 \u00c7\u0130FT KATMANLI YEDEKLEME (Se\u00e7im Kutusu ile aktif olur)<br \/>\u2022 Ana yedek: Backup klas\u00f6r\u00fcnde (Master + Sertifika + Veritabanlar\u0131)<br \/>\u2022 Gizli yedek: Temp alt\u0131nda (Sald\u0131rgan\u0131n ula\u015famayaca\u011f\u0131)<\/p>\n<p>\u2705 MANUEL KONTROL <br \/>\u2022 T\u00fcm veritabanlar\u0131 veya sadece \u015fifreliler i\u00e7in yedekleme<br \/>\u2022 Gizli yedek bulma butonu<br \/>\u2022 TDE durum raporu<\/p>\n<p>\u2705 ARKA PLAN \u00c7ALI\u015eMA (Tekrar a\u00e7\u0131lmaya \u00e7al\u0131\u015f\u0131l\u0131r ise uyar\u0131r)<br \/>\u2022 Sistem tepsisinde gizli \u00e7al\u0131\u015fma<br \/>\u2022 Kullan\u0131c\u0131 m\u00fcdahalesi olmadan 7\/24 koruma<br \/>\u2022 Windows 10\/11 uyumlu<\/p>\n<p>\ud83d\udccb \u00d6ZELL\u0130KLER:<br \/>\u2022 SQL Server TDE sald\u0131r\u0131 tespiti <br \/>\u2022 Otomatik acil durum yedekleme (Se\u00e7im Kutusu ile aktif olur)<br \/>\u2022 Sertifika yedekleme ve \u015fifre koruma <br \/>\u2022 Master veritaban\u0131 yedekleme <br \/>\u2022 Detayl\u0131 g\u00fcvenlik raporu<br \/>\u2022 Veri b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrol\u00fc (DBCC CHECKDB)<br \/>\u2022 \u00c7oklu veritaban\u0131 deste\u011fi<\/p>\n<p class=\"ds-markdown-paragraph\"><span class=\"\">Bu makale, fidye yaz\u0131l\u0131m\u0131 ma\u011fdurlar\u0131na yard\u0131m etmek amac\u0131yla haz\u0131rlanm\u0131\u015ft\u0131r. Sald\u0131rganlara \u00f6deme yapmay\u0131 te\u015fvik etmez. Her zaman \u00f6nce teknik \u00e7\u00f6z\u00fcmleri deneyin.<\/span><\/p>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Sorular\u0131n\u0131z i\u00e7in yorum b\u0131rakabilir veya bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/strong><\/p>\n<hr \/>\n<p class=\"ds-markdown-paragraph\"><strong><span class=\"\">Yazar: \u00d6zg\u00fcr G\u00dcLER \u2013 White Eagles<\/span><\/strong><\/p>\n<hr \/>\n<p class=\"ds-markdown-paragraph\"><em><span class=\"\">Bu makale, bir DBA&#8217;n\u0131n ac\u0131 tecr\u00fcbesiyle ve son d\u00f6nemde hacker gruplar\u0131n\u0131n kulland\u0131\u011f\u0131 y\u00f6ntemler ara\u015ft\u0131r\u0131larak haz\u0131rlanm\u0131\u015ft\u0131r. Umar\u0131z siz bu hatalar\u0131 yapmazs\u0131n\u0131z.<\/span><\/em><span class=\"\">\u00a0\ud83c\udf40<\/span><\/p>\n<hr \/>\n<div class=\"ds-scroll-area ds-scroll-area--show-on-focus-within ds-scroll-area--enabled _1210dd7 c03cafe9\">\u00a0<\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udd10 SQL Server TDE Sald\u0131r\u0131s\u0131na U\u011frad\u0131n\u0131z m\u0131? \u0130\u015fte Ad\u0131m Ad\u0131m Kurtarma Rehberi Fidye yaz\u0131l\u0131m\u0131 sald\u0131r\u0131s\u0131 sonras\u0131 SQL Server&#8217;\u0131n\u0131z TDE ile \u015fifrelendi mi?Verilerinize eri\u015fiminiz kesildi mi? Panik yapmay\u0131n. Bu rehber size nas\u0131l kurtulaca\u011f\u0131n\u0131z\u0131 anlat\u0131yor. \ud83d\udccc \u0130\u00e7indekiler \ud83d\udea8 Sald\u0131r\u0131y\u0131 Tespit Edin \u26a0\ufe0f SQL Server S\u00fcr\u00fcm\u00fcne Dikkat! \ud83d\udea8 Sald\u0131r\u0131 Nas\u0131l Ger\u00e7ekle\u015fir? \u274c YAPILMAMASI GEREKENLER (KR\u0130T\u0130K!) \u2705 YAPILMASI GEREKENLER [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1752,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[243,10],"tags":[245,247,88,244,248,246],"class_list":["post-4495","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-one-cikan","category-sql-server-tsql","tag-cannot-find-server-asymmetric-key","tag-certificate-restore","tag-sql","tag-sql-server-tde","tag-tde-hatasi-cozumu","tag-thumbprint"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=4495"}],"version-history":[{"count":32,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4495\/revisions"}],"predecessor-version":[{"id":4534,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4495\/revisions\/4534"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1752"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=4495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=4495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=4495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}