{"id":4495,"date":"2026-06-05T09:00:00","date_gmt":"2026-06-05T06:00:00","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=4495"},"modified":"2026-06-09T17:18:49","modified_gmt":"2026-06-09T14:18:49","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 Hatas\u0131: Cannot find server asymmetric key thumbprint – \u00c7\u00f6z\u00fcm ve Kurtarma Rehberi"},"content":{"rendered":"

SQL Server TDE Hatas\u0131: “Cannot find server asymmetric key” – \u00c7\u00f6z\u00fcm, G\u00fcvenlik A\u00e7\u0131\u011f\u0131 ve Otomatik \u0130zleme<\/strong><\/p>\n

SQL Server’da TDE restore hatas\u0131 ‘Cannot find server asymmetric key’ ile kar\u015f\u0131la\u015ft\u0131n\u0131z m\u0131? Certificate backup alma, restore etme ve format sonras\u0131 kurtarma y\u00f6ntemleri. Ayr\u0131ca TDE’nin bilinmeyen g\u00fcvenlik a\u00e7\u0131\u011f\u0131: Sysadmin verilerinizi nas\u0131l \u00e7alabilir?<\/strong><\/p>\n

Veritaban\u0131nda TDE (Transparent Data Encryption) Kullan\u0131lm\u0131\u015fsa G\u00f6r\u00fclen Hata<\/p>\n

**Hata Mesaj\u0131:**<\/p>\n

Cannot find server asymmetric key with thumbprint ‘0x7b8626f7e9b646cb8702530018600bf3’<\/p>\n

### Bu hata ne anlama geliyor?<\/strong><\/p>\n

Restore etmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z veritaban\u0131, eski SQL Server instance’\u0131nda bulunan bir **Certificate** veya **Asymmetric Key**’e ba\u011fl\u0131. Yeni sunucuda bu g\u00fcvenlik nesnesi bulunmad\u0131\u011f\u0131 i\u00e7in SQL Server veritaban\u0131n\u0131 a\u00e7am\u0131yor.<\/p>\n

—<\/p>\n

## \u00d6ncelikle TDE Kullan\u0131l\u0131p Kullan\u0131lmad\u0131\u011f\u0131n\u0131 Kontrol Edin<\/strong><\/p>\n

**Eski sunucuda thumbprint ile sorgulama:**<\/strong><\/p>\n

SELECT name, thumbprint
\nFROM sys.certificates
\nWHERE thumbprint = 0x7b8626f7e9b646cb8702530018600bf3;<\/p>\n

Eski sunucuda genel kontrol:<\/strong>
\nSELECT
\ndb.name AS DatabaseName,
\ndek.encryption_state,
\ndek.percent_complete,
\ndek.key_algorithm,
\ndek.key_length
\nFROM sys.databases db
\nLEFT JOIN sys.dm_database_encryption_keys dek
\nON db.database_id = dek.database_id;<\/p>\n

\u2705 E\u011fer veritaban\u0131n\u0131z listeleniyorsa \u2192 TDE aktif demektir.<\/strong><\/p>\n

TDE Restore \u0130\u015flemi \u0130\u00e7in Gerekli Ad\u0131mlar<\/strong>
\nEski sunucudan a\u015fa\u011f\u0131daki nesneleri alman\u0131z gerekir:<\/strong><\/p>\n

Database Master Key (DMK) – master sistem veritaban\u0131nda olu\u015fturulur ve certificate’\u0131 korur<\/p>\n

Certificate<\/p>\n

Certificate Private Key<\/p>\n

master veritaban\u0131nda zaten bir DMK olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek \u00f6nemlidir:<\/p>\n

SELECT * FROM sys.symmetric_keys WHERE name = ‘##MS_DatabaseMasterKey##’;<\/p>\n

1. Ad\u0131m: Eski sunucuda Certificate’\u0131 Backup Al\u0131n<\/strong>
\nBACKUP CERTIFICATE MyTDECert
\nTO FILE = ‘D:\\Backup\\MyTDECert.cer’
\nWITH PRIVATE KEY
\n(
\nFILE = ‘D:\\Backup\\MyTDECert.pvk’,
\nENCRYPTION BY PASSWORD = ‘StrongPassword123!’
\n);<\/p>\n

Not: INIT se\u00e7ene\u011fi ile mevcut dosyan\u0131n \u00fczerine yazabilirsiniz (iyi al\u0131\u015fkanl\u0131k).<\/p>\n

2. Ad\u0131m: Yeni sunucuda Certificate’\u0131 Restore Edin<\/strong><\/p>\n

— Master veritaban\u0131nda \u00e7al\u0131\u015ft\u0131r\u0131n
\nUSE master;
\nGO<\/p>\n

— Database Master Key olu\u015fturun (daha \u00f6nce yoksa)
\nCREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘MasterKeyPassword123!’;
\nGO<\/p>\n

— Certificate’\u0131 geri y\u00fckleyin
\nCREATE CERTIFICATE MyTDECert
\nFROM FILE = ‘D:\\Backup\\MyTDECert.cer’
\nWITH PRIVATE KEY
\n(
\nFILE = ‘D:\\Backup\\MyTDECert.pvk’,
\nDECRYPTION BY PASSWORD = ‘StrongPassword123!’
\n);
\nGO<\/p>\n

Not: Certificate ismi (MyTDECert) eski sunucudakiyle ayn\u0131 olabilir ama zorunlu de\u011fildir. \u00d6nemli olan thumbprint’in e\u015fle\u015fmesidir.<\/p>\n

3. Ad\u0131m: Art\u0131k veritaban\u0131n\u0131 restore edebilirsiniz<\/strong><\/p>\n

RESTORE DATABASE MyDatabase
\nFROM DISK = ‘D:\\Backup\\MyDatabase.bak’
\nWITH MOVE ‘MyDatabase_Data’ TO ‘E:\\Data\\MyDatabase.mdf’,
\nMOVE ‘MyDatabase_Log’ TO ‘F:\\Log\\MyDatabase.ldf’,
\nREPLACE;<\/p>\n

Restore Sonras\u0131 Kontrol<\/strong>
\nUSE YourDatabaseName;
\nGO
\nSELECT
\ndb.name AS DatabaseName,
\ndek.encryption_state,
\ndek.percent_complete,
\ndek.key_algorithm,
\ndek.key_length,
\nCASE dek.encryption_state
\nWHEN 0 THEN ‘No encryption’
\nWHEN 1 THEN ‘Unencrypted’
\nWHEN 2 THEN ‘Encryption in progress’
\nWHEN 3 THEN ‘Encrypted’
\nWHEN 4 THEN ‘Key change in progress’
\nWHEN 5 THEN ‘Decryption in progress’
\nWHEN 6 THEN ‘Protection change in progress’
\nEND AS EncryptionStateDescription
\nFROM sys.dm_database_encryption_keys dek
\nINNER JOIN sys.databases db ON dek.database_id = db.database_id
\nWHERE db.name = ‘YourDatabaseName’;<\/p>\n

Beklenen Sonu\u00e7:<\/strong><\/p>\n

encryption_state = 3 (Encrypted)<\/p>\n

key_algorithm ve key_length eski sunucudakiyle ayn\u0131 olmal\u0131<\/p>\n

\u2757 Format Sonras\u0131 Yaln\u0131zca .bak Dosyas\u0131 Kald\u0131ysa<\/strong>
\nE\u011fer format att\u0131ktan sonra yaln\u0131zca .bak dosyan\u0131z kald\u0131ysa ve TDE Certificate ile Private Key yede\u011fi yoksa, bu veritaban\u0131n\u0131 yeni bir sunucuda a\u00e7man\u0131z teknik olarak imkans\u0131zd\u0131r.<\/p>\n

\u26a0\ufe0f Neden Kurtaram\u0131yorsunuz?<\/strong>
\nTDE’nin \u00e7al\u0131\u015fma mant\u0131\u011f\u0131, veriyi \u015fifrelemek i\u00e7in kullan\u0131lan “anahtar” ile veritaban\u0131 dosyas\u0131n\u0131 (.bak veya .mdf) birbirinden ay\u0131rmakt\u0131r.<\/p>\n

Database Encryption Key (DEK): Veritaban\u0131 i\u00e7inde saklan\u0131r, ancak Certificate ile \u015fifrelenmi\u015ftir<\/p>\n

Certificate & Private Key: Veritaban\u0131n\u0131 a\u00e7an as\u0131l anahtard\u0131r. Bu sertifika master veritaban\u0131nda saklan\u0131r ve format att\u0131\u011f\u0131n\u0131z i\u00e7in silinmi\u015ftir<\/p>\n

Elinizde sadece .bak dosyas\u0131 varsa, bu \u015fifreli bir kutudur; ancak kutuyu a\u00e7acak fiziksel anahtar\u0131n\u0131z (Certificate) yoktur.<\/p>\n

Not: Diskten .mdf\/.ldf dosyalar\u0131 kurtar\u0131lsa bile, ayn\u0131 certificate olmadan bu dosyalar da attach edilemez. TDE \u015fifrelemesi, dosya d\u00fczeyinde de ge\u00e7erlidir.<\/p>\n

\ud83d\udee0\ufe0f Kurtulmak \u0130\u00e7in Tek \u00c7\u00f6z\u00fcm (E\u011fer M\u00fcmk\u00fcnse)<\/strong>
\nBu noktada tek umudunuz, format atmadan \u00f6nce ald\u0131\u011f\u0131n\u0131z
\nCertificate ve Private Key yedeklerini (MyTDECert.cer ve MyTDECert.pvk dosyalar\u0131) bulmakt\u0131r.<\/p>\n

| Durum\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Sonu\u00e7
\n|———————|—————————————————————-
\n| Dosyalar var ise\u00a0 \u00a0| Yeni sunucuda Certificate geri y\u00fcklenir, restore ba\u015far\u0131l\u0131 olur
\n| Dosyalar yok ise\u00a0 | Veri kayb\u0131 kesindir. Kurtarma imkans\u0131zd\u0131r.<\/p>\n

\ud83d\udea8 Bilmeniz Gereken Kritik G\u00fcvenlik Riski: Sysadmin Verilerinizi \u00c7alabilir<\/strong>
\nBu makaleyi yazma sebeplerimden biri de, TDE hakk\u0131nda yayg\u0131n bir yan\u0131lg\u0131y\u0131 d\u00fczeltmek.<\/p>\n

Bir\u00e7ok ki\u015fi (ben de dahil) TDE’nin verileri yetkisiz eri\u015fime kar\u015f\u0131 tamamen korudu\u011funu d\u00fc\u015f\u00fcn\u00fcyor. Ancak durum tam olarak \u00f6yle de\u011fil.<\/p>\n

E\u011fer bir sald\u0131rgan SQL Server’da sysadmin yetkisi elde ederse veya sunucuya fiziksel eri\u015fimi olursa, TDE’yi a\u015fmak \u00e7ok kolayd\u0131r.<\/p>\n

Nas\u0131l m\u0131? Sadece \u015fu ad\u0131mlar\u0131 izler:<\/strong><\/p>\n

Ad\u0131m Yapt\u0131\u011f\u0131 \u0130\u015flem
\n1 Sertifikay\u0131 Yedekler: BACKUP CERTIFICATE …
\nkomutuyla TDE sertifikas\u0131n\u0131 ve \u00f6zel anahtar\u0131n\u0131 kendi belirledi\u011fi \u015fifreyle dosyaya yedekler
\n2 Veritaban\u0131n\u0131 Yedekler: \u015eifreli veritaban\u0131n\u0131n bir yede\u011fini al\u0131r
\n3 Kendi Sunucusunda A\u00e7ar: Kendi SQL Server’\u0131nda sertifikay\u0131 geri y\u00fckleyerek
\n(CREATE CERTIFICATE …) veritaban\u0131n\u0131 a\u00e7ar ve t\u00fcm verileri d\u00fcz metin olarak okur<\/p>\n

Peki Bu Ne Anlama Geliyor?<\/strong><\/p>\n

TDE, “veritaban\u0131 dosyalar\u0131n\u0131 elinde bulunduran ancak sunucuya eri\u015fimi olmayan” ki\u015filere kar\u015f\u0131 etkilidir (\u00f6rne\u011fin, bir SAN y\u00f6neticisi veya fiziksel diski \u00e7alan h\u0131rs\u0131z)<\/p>\n

sysadmin gibi y\u00fcksek yetkili bir kullan\u0131c\u0131ya veya yetkilerini ele ge\u00e7iren bir sald\u0131rgana kar\u015f\u0131 TDE tek ba\u015f\u0131na bir koruma sa\u011flamaz<\/p>\n

Bu nedenle, TDE’yi bir “derinlemesine savunma” stratejisinin sadece bir katman\u0131 olarak g\u00f6rmeli,
\nAlways Encrypted gibi veriyi kullan\u0131m s\u0131ras\u0131nda da koruyan y\u00f6ntemlerle veya s\u0131k\u0131 eri\u015fim denetimleriyle desteklemelisiniz.<\/p>\n

\ud83d\udce2 Proaktif \u00c7\u00f6z\u00fcm: TDE Aktif Oldu\u011funda Sizi Uyaracak SQL Job<\/strong>
\nYukar\u0131da anlatt\u0131\u011f\u0131m\u0131z senaryoya bir daha d\u00fc\u015fmemek i\u00e7in,
\nTDE’nin hangi veritabanlar\u0131nda aktif oldu\u011funu otomatik olarak izleyen bir SQL Agent Job’u kurabilirsiniz.<\/p>\n

Bu job:<\/p>\n

Her sabah \u00e7al\u0131\u015f\u0131r<\/p>\n

TDE a\u00e7\u0131k olan veritabanlar\u0131n\u0131 kontrol eder<\/p>\n

E\u011fer TDE aktif veritaban\u0131 varsa size e-posta g\u00f6nderir<\/p>\n

\ud83d\udee0\ufe0f Haz\u0131r SQL Job Script’i<\/p>\n

— 1. \u00d6nce bir operat\u00f6r olu\u015fturun (e-posta adresinizle)
\nUSE msdb;
\nGO<\/p>\n

EXEC msdb.dbo.sp_add_operator
\n@name = N’TDE Uyari’,
\n@enabled = 1,
\n@email_address = N’dba@sirketiniz.com’; — Kendi e-posta adresinizle de\u011fi\u015ftirin
\nGO<\/p>\n

— 2. Job’u olu\u015fturun
\nEXEC dbo.sp_add_job
\n@job_name = N’TDE – Aktif Veritabanlarini Kontrol Et’,
\n@enabled = 1,
\n@description = N’TDE \u015fifrelemesi aktif olan veritabanlar\u0131n\u0131 listeler ve uyar\u0131 g\u00f6nderir’,
\n@owner_login_name = N’sa’;
\nGO<\/p>\n

— 3. Job’a ad\u0131m ekleyin
\nEXEC dbo.sp_add_jobstep
\n@job_name = N’TDE – Aktif Veritabanlarini Kontrol Et’,
\n@step_name = N’TDE Kontrol Sorgusu’,
\n@subsystem = N’TSQL’,
\n@command = N’
\n— TDE aktif veritabanlar\u0131n\u0131 bul
\nDECLARE @Subject NVARCHAR(255);
\nDECLARE @Body NVARCHAR(MAX);<\/p>\n

SET @Subject = ”TDE RAPORU – ” + @@SERVERNAME + ” – ” + CONVERT(NVARCHAR(10), GETDATE(), 104);<\/p>\n

SET @Body = ”A\u015fa\u011f\u0131daki veritabanlar\u0131nda TDE aktiftir:”
\n+ CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
\n+ ”<table border=”1″ cellpadding=”5″>”
\n+ ”<tr><th>Veritaban\u0131 Ad\u0131<\/th><th>\u015eifreleme Durumu<\/th><th>Anahtar Algoritmas\u0131<\/th><th>Anahtar Uzunlu\u011fu<\/th><\/td>”;<\/p>\n

SELECT @Body = @Body +
\n”<tr>”
\n+ ”<td>” + db.name + ”<\/td>”
\n+ ”<td>” +
\nCASE dek.encryption_state
\nWHEN 0 THEN ”\u015eifreleme yok”
\nWHEN 1 THEN ”\u015eifrelenmemi\u015f”
\nWHEN 2 THEN ”\u015eifreleme devam ediyor”
\nWHEN 3 THEN ”\u015eifrelenmi\u015f”
\nWHEN 4 THEN ”Anahtar de\u011fi\u015fimi devam ediyor”
\nWHEN 5 THEN ”\u015eifre \u00e7\u00f6zme devam ediyor”
\nWHEN 6 THEN ”Koruma de\u011fi\u015fimi devam ediyor”
\nEND
\n+ ”<\/td>”
\n+ ”<td>” + ISNULL(dek.key_algorithm, ”-”) + ”<\/td>”
\n+ ”<td>” + ISNULL(CAST(dek.key_length AS NVARCHAR), ”-”) + ”<\/td>”
\n+ ”<\/tr>”
\nFROM sys.databases db
\nLEFT JOIN sys.dm_database_encryption_keys dek
\nON db.database_id = dek.database_id
\nWHERE dek.encryption_state = 3;<\/p>\n

SET @Body = @Body + ”<\/table>”;<\/p>\n

IF EXISTS (SELECT 1 FROM sys.databases db
\nLEFT JOIN sys.dm_database_encryption_keys dek
\nON db.database_id = dek.database_id
\nWHERE dek.encryption_state = 3)
\nBEGIN
\nEXEC msdb.dbo.sp_send_dbmail
\n@profile_name = ”MailProfiliniz”,
\n@recipients = ”dba@sirketiniz.com”,
\n@subject = @Subject,
\n@body = @Body,
\n@body_format = ”HTML”;
\nEND
\n‘,
\n@database_name = N’master’;
\nGO<\/p>\n

— 4. Job’a zamanlama ekleyin (Her g\u00fcn sabah 08:00’de)
\nEXEC dbo.sp_add_schedule
\n@schedule_name = N’Gunluk Sabah 08:00′,
\n@freq_type = 4,
\n@freq_interval = 1,
\n@active_start_time = 80000;
\nGO<\/p>\n

— 5. Job’u schedule ile ili\u015fkilendirin
\nEXEC dbo.sp_attach_schedule
\n@job_name = N’TDE – Aktif Veritabanlarini Kontrol Et’,
\n@schedule_name = N’Gunluk Sabah 08:00′;
\nGO<\/p>\n

\ud83d\udce7 Database Mail Nas\u0131l Kurulur?
\n— Database Mail’i etkinle\u015ftir
\nEXEC sp_configure ‘Database Mail XPs’, 1;
\nRECONFIGURE;
\nGO<\/p>\n

— Mail profili olu\u015ftur
\nEXEC sysmail_add_profile_sp @profile_name = ‘MailProfiliniz’;<\/p>\n

— Hesap ekle
\nEXEC sysmail_add_account_sp
\n@account_name = ‘SQLMailAccount’,
\n@email_address = ‘sqlalert@sirketiniz.com’,
\n@display_name = ‘SQL Server Alert’,
\n@mailserver_name = ‘smtp.sirketiniz.com’, — Kendi SMTP sunucunuz
\n@port = 25;<\/p>\n

— Profil ile hesab\u0131 ili\u015fkilendir
\nEXEC sysmail_add_profileaccount_sp
\n@profile_name = ‘MailProfiliniz’,
\n@account_name = ‘SQLMailAccount’,
\n@sequence_number = 1;<\/p>\n

— Profili SQL Server’a tan\u0131t
\nEXEC sysmail_add_principalprofile_sp
\n@profile_name = ‘MailProfiliniz’,
\n@principal_name = ‘public’,
\n@is_default = 1;
\nGO<\/p>\n

\ud83d\udd14 Alternatif: Sadece Log’a Yazan Basit Versiyon<\/strong>
\nE-posta ayarlar\u0131yla u\u011fra\u015fmak istemiyorsan\u0131z, sadece SQL Server log’una uyar\u0131 yazan job step’i:<\/strong><\/p>\n

IF EXISTS (SELECT 1 FROM sys.dm_database_encryption_keys WHERE encryption_state = 3)
\nBEGIN
\nDECLARE @Message NVARCHAR(500);
\nSET @Message = ‘UYARI: TDE aktif veritabanlar\u0131 var! Sorgu: SELECT * FROM sys.dm_database_encryption_keys WHERE encryption_state = 3’;
\nEXEC xp_logevent 50001, @Message, ‘ERROR’;
\nEND<\/p>\n

\ud83d\udca1 \u0130lerisi \u0130\u00e7in Hayati Tavsiyeler<\/strong>
\nBu ac\u0131 tecr\u00fcbeyi bir daha ya\u015famamak i\u00e7in:<\/strong><\/p>\n

| Tavsiye\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| A\u00e7\u0131klama
\n|———————————|——————————————————————————————————
\n| Certificate’lar\u0131 Yedekleyin | TDE a\u00e7t\u0131\u011f\u0131n\u0131z anda sertifikay\u0131 ve \u00f6zel anahtar\u0131 g\u00fcvenli bir dosyaya yedekleyin (`BACKUP CERTIFICATE`)
\n| Master DB’yi Yedekleyin\u00a0 \u00a0| Sistem veritabanlar\u0131n\u0131 (\u00f6zellikle `master`) d\u00fczenli yedekleyin. `master` yede\u011fi sertifikay\u0131 da i\u00e7erir
\n| Parolalar\u0131 Saklay\u0131n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Certificate yede\u011fi al\u0131rken kulland\u0131\u011f\u0131n\u0131z parolay\u0131 g\u00fcvenli bir \u015fifre kasas\u0131nda tutun<\/p>\n

\ud83d\udccc \u00d6zet<\/strong>
\nAnahtar olmadan \u015fifre a\u00e7\u0131lmaz. E\u011fer sertifika dosyalar\u0131n\u0131z yoksa, TDE’li veritaban\u0131 yede\u011finizin bir anlam\u0131 kalmam\u0131\u015ft\u0131r.<\/strong><\/p>\n

Bu rehberde \u00f6\u011frendikleriniz:<\/strong><\/p>\n

\u2705 Hatan\u0131n ne anlama geldi\u011fini<\/p>\n

\u2705 Certificate backup\/restore ad\u0131mlar\u0131n\u0131<\/p>\n

\u2705 Format sonras\u0131 kurtarman\u0131n imkans\u0131z oldu\u011funu<\/p>\n

\u2705 Sysadmin’in TDE’yi nas\u0131l a\u015fabilece\u011fini (g\u00fcvenlik a\u00e7\u0131\u011f\u0131)<\/p>\n

\u2705 TDE’yi otomatik izleyen SQL Job kurmay\u0131<\/p>\n

Bu makale, bir DBA’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.<\/p>\n

Yazar: \u00d6zg\u00fcr G\u00dcLER \u2013 White Eagles<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

SQL Server TDE Hatas\u0131: “Cannot find server asymmetric key” – \u00c7\u00f6z\u00fcm, G\u00fcvenlik A\u00e7\u0131\u011f\u0131 ve Otomatik \u0130zleme SQL Server’da TDE restore hatas\u0131 ‘Cannot find server asymmetric key’ ile kar\u015f\u0131la\u015ft\u0131n\u0131z m\u0131? Certificate backup alma, restore etme ve format sonras\u0131 kurtarma y\u00f6ntemleri. Ayr\u0131ca TDE’nin bilinmeyen g\u00fcvenlik a\u00e7\u0131\u011f\u0131: Sysadmin verilerinizi nas\u0131l \u00e7alabilir? Veritaban\u0131nda TDE (Transparent Data Encryption) Kullan\u0131lm\u0131\u015fsa G\u00f6r\u00fclen […]<\/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":6,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4495\/revisions"}],"predecessor-version":[{"id":4502,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4495\/revisions\/4502"}],"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}]}}