{"id":203,"date":"2018-06-07T21:02:24","date_gmt":"2018-06-07T21:02:24","guid":{"rendered":"http:\/\/dbtut.com\/?p=203"},"modified":"2021-02-08T07:32:44","modified_gmt":"2021-02-08T07:32:44","slug":"how-to-delete-the-transaction-log-file-on-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/","title":{"rendered":"SQL Server Delete Transaction Log File"},"content":{"rendered":"

Can I Delete SQL Server Transaction Log File?<\/h2>\n

We can not delete primary transaction log file, but we can delete secondary log files in SQL Server.<\/p>\n

Sometimes we can create a second log file on another disk as a workaround because the log file is full.<\/p>\n

If we do not delete these temporary secondary log files over time, log file count will increase.<\/p>\n

When we have free space on the disk where the first log file is located, or when we move this first log file to another disk with sufficient space, we can delete these temporary secondary log files.<\/p>\n

To see how a second log file is added to the database, you may want to read the article “How To Add The Second Log File to the Database”.<\/a><\/p>\n

If your database’s recovery model is Full Recovery Model, I recommend that you backup your transaction log. So, your transaction log file automatically truncated after log backup and this prevents your transaction log to growing too much.<\/p>\n

You may want to read the following articles to learn detailed information about recovery models and transaction log.<\/p>\n

“What is Database Recovery Model<\/a>“,<\/p>\n

“What is SQL Server Transaction Log<\/a>“,<\/p>\n

“How To Shrink SQL Server Transaction Log<\/a>”<\/p>\n

Empty Secondary Transaction Log File Before Removing<\/h2>\n

After backing up the transaction log, we need to shrink the log file we want to delete with empty option.<\/p>\n

First we right-click on the database and click Tasks-> Shrink-> Files.<\/p>\n

\"\"<\/p>\n

We select the Log option from the File type section as shown below.<\/p>\n

We choose the file we want to shrink from the file name.<\/p>\n

In the Shrink action section, we also select “Empty file by migrating the data to other files in the same filegroup”.<\/p>\n

In this way we are able to transfer the data in the log file to the other log files.<\/p>\n

\"\"<\/p>\n

Before we click Ok, let’s take the script by clicking on the “Script” at the top left. This will output a script like the following.<\/p>\n

USE [TestDB]\r\nGO\r\nDBCC SHRINKFILE (N'TestDB_log2' , EMPTYFILE)\r\nGO<\/pre>\n
Remove Secondary Transaction Log File<\/h2>\n
Right-click on the database and click Properties.<\/p>\n
\"\"<\/p>\n
Go the “Files” tab on the left side and select the log file that you want to delete from the “database files” secion and click on the remove button at the bottom right. Finally, click “Script” on the upper side to get the remove secondary log file script.<\/p>\n
\"\"<\/p>\n
This will output a script like the following.<\/p>\n
USE [TestDB]\r\nGO\r\nALTER DATABASE [TestDB] REMOVE FILE [TestDB_log2]\r\nGO\r\n<\/pre>\n
You can remove the log file by combining these two scripts as follows.<\/p>\n
USE [TestDB]\r\nGO\r\nDBCC SHRINKFILE (N'TestDB_log2' , EMPTYFILE)\r\nGO\r\nALTER DATABASE [TestDB]\u00a0 REMOVE FILE [TestDB_log2]\r\nGO<\/pre>\n
After removing the secondary log file, it may appear that it has not been removed from the database for a while. Do not worry, this is normal. It will return to normal state after a while.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Can I Delete SQL Server Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files in SQL Server. Sometimes we can create a second log file on another disk as a workaround because the log file is full. If we do not delete these temporary secondary log …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":11079,"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,"footnotes":""},"categories":[3],"tags":[5183,104,5182,10365,2913,2914,2916,106,103,5178,101,5186,5180,107,2915,2917,2918,105,5179,5181,56,5176,5177,77,5185,5175,102],"class_list":["post-203","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-a-file-must-be-empty-before-it-can-be-deleted","tag-alter-database","tag-can-i-delete-ldf-file","tag-can-i-delete-sql-server-transaction-log-file","tag-can-i-delete-sql-transaction-log-files","tag-can-we-delete-ldf-file-sql-server","tag-can-we-delete-sql-server-database-transaction-log-file","tag-dbcc-shrinkfile","tag-delete-log-file","tag-delete-sql-database-log-file","tag-delete-transaction-log","tag-empty-secondary-log-file","tag-empty-secondary-transaction-log-file","tag-emtyfile","tag-how-can-delete-ldf-file-in-sql-server","tag-how-do-i-delete-a-log-file","tag-how-do-i-delete-a-sql-transaction-log","tag-remove-file","tag-remove-secondary-transaction-log-file","tag-remove-unnecessary-sql-server-transaction-log-files","tag-shrink-log","tag-sql-clear-log-file","tag-sql-server-remove-secondary-log-file","tag-sql-server-transaction-log","tag-the-file-cannot-be-removed-because-it-is-not-empty","tag-transaction-log-delete","tag-transaction-log-file"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":7299,"today_views":0},"yoast_head":"\nSQL Server Delete Transaction Log File - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Delete The Transaction Log File On SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Delete Transaction Log File - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Delete The Transaction Log File On SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-07T21:02:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-08T07:32:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png\" \/>\n\t<meta property=\"og:image:width\" content=\"633\" \/>\n\t<meta property=\"og:image:height\" content=\"415\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"SQL Server Delete Transaction Log File\",\"datePublished\":\"2018-06-07T21:02:24+00:00\",\"dateModified\":\"2021-02-08T07:32:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\"},\"wordCount\":458,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png\",\"keywords\":[\"A file must be empty before it can be deleted\",\"ALTER DATABASE\",\"Can I delete LDF file?\",\"Can I Delete SQL Server Transaction Log File\",\"Can I delete SQL transaction log files?\",\"Can we delete LDF file SQL Server?\",\"Can we delete SQL Server database transaction log file?\",\"DBCC SHRINKFILE\",\"Delete Log File\",\"delete sql database log file\",\"Delete Transaction Log\",\"Empty Secondary Log File\",\"Empty Secondary Transaction Log File\",\"EMTYFILE\",\"How can delete LDF file in SQL Server?\",\"How do I delete a log file?\",\"How do I delete a SQL transaction log?\",\"REMOVE FILE\",\"Remove Secondary Transaction Log File\",\"Remove Unnecessary SQL Server Transaction Log Files\",\"shrink log\",\"sql clear log file\",\"sql server remove secondary log file\",\"SQL Server Transaction Log\",\"The file cannot be removed because it is not empty.\",\"transaction log delete\",\"Transaction Log File\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\",\"name\":\"SQL Server Delete Transaction Log File - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png\",\"datePublished\":\"2018-06-07T21:02:24+00:00\",\"dateModified\":\"2021-02-08T07:32:44+00:00\",\"description\":\"How To Delete The Transaction Log File On SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png\",\"width\":633,\"height\":415},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Delete Transaction Log File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Delete Transaction Log File - Database Tutorials","description":"How To Delete The Transaction Log File On SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Delete Transaction Log File - Database Tutorials","og_description":"How To Delete The Transaction Log File On SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-07T21:02:24+00:00","article_modified_time":"2021-02-08T07:32:44+00:00","og_image":[{"width":633,"height":415,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"SQL Server Delete Transaction Log File","datePublished":"2018-06-07T21:02:24+00:00","dateModified":"2021-02-08T07:32:44+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/"},"wordCount":458,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png","keywords":["A file must be empty before it can be deleted","ALTER DATABASE","Can I delete LDF file?","Can I Delete SQL Server Transaction Log File","Can I delete SQL transaction log files?","Can we delete LDF file SQL Server?","Can we delete SQL Server database transaction log file?","DBCC SHRINKFILE","Delete Log File","delete sql database log file","Delete Transaction Log","Empty Secondary Log File","Empty Secondary Transaction Log File","EMTYFILE","How can delete LDF file in SQL Server?","How do I delete a log file?","How do I delete a SQL transaction log?","REMOVE FILE","Remove Secondary Transaction Log File","Remove Unnecessary SQL Server Transaction Log Files","shrink log","sql clear log file","sql server remove secondary log file","SQL Server Transaction Log","The file cannot be removed because it is not empty.","transaction log delete","Transaction Log File"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/","name":"SQL Server Delete Transaction Log File - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png","datePublished":"2018-06-07T21:02:24+00:00","dateModified":"2021-02-08T07:32:44+00:00","description":"How To Delete The Transaction Log File On SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-16.png","width":633,"height":415},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/07\/how-to-delete-the-transaction-log-file-on-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Delete Transaction Log File"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=203"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11079"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}