{"id":163,"date":"2018-06-06T19:51:57","date_gmt":"2018-06-06T19:51:57","guid":{"rendered":"http:\/\/dbtut.com\/?p=163"},"modified":"2019-10-31T14:42:10","modified_gmt":"2019-10-31T14:42:10","slug":"how-to-add-second-log-file-to-the-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/","title":{"rendered":"How To Add Second Log File To The Database"},"content":{"rendered":"<h1>Why we want to add second log file?<\/h1>\n<p>It is a process that we usually perform when there is no free space in the disk where the log file exists.<\/p>\n<p>By creating a second log file on another disk, we allow the database&#8217;s log operations to continue on new disk.<\/p>\n<p lang=\"en-US\">You can find detailed information about the log file in the article &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is SQL Server Transaction Log<\/a>&#8220;.<\/p>\n<p>For a clearer understanding of the subject, let me explain logic of writing data to the log file.<\/p>\n<h2>Is auto log growth of the current Transaction Log file enabled?<\/h2>\n<p>If so, is there enough disk space on the log file, or does the log file has reached its maximum size (maximum transaction log file size is 2TB)?<\/p>\n<p>If SQL Server can write to the first log file, it always writes to the first log file, but when it is not possible to write to the first log file, it writes to the other log file.<\/p>\n<p lang=\"en-US\">In other words, if you create 5 log files in one database, SQL Server will not be able to write logs to 5 different disks at the same time.<\/p>\n<p lang=\"en-US\"><strong>Therefore, increasing the number of log files do not increase the performance.<\/strong><\/p>\n<p><span lang=\"en-US\">If you have more than one log file, you can enable <\/span><span lang=\"en-US\">auto growth of the log file that you want the database to use and then disable auto growth of the other log files. <\/span><\/p>\n<p><span lang=\"en-US\">You can do the same for data files. <\/span><\/p>\n<p><span lang=\"en-US\">You can find the necessary details in the article &#8220;<\/span><a title=\"How To Add Another Disk For a Database Without Interruption On SQL Server\" href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/30\/how-to-add-another-disk-for-a-database-without-interruption-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Add Another Disk For a Database Without Interruption On SQL Server<\/a><span lang=\"en-US\">&#8221; when there is no free space on the disks.<\/span><\/p>\n<h2 lang=\"en-US\">Create a second log file in the database:<\/h2>\n<p>Right click on the database and click properties as below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/428.png\" \/><\/p>\n<p>Then go to the Files tab and click Add on the bottom right corner of the screen.<\/p>\n<p>As you can see on the screen below, we will create a new Logical Name for the new transaction log file. I named it as TestLog.<\/p>\n<p>In the File Type section, we choose the LOG option to indicate that this new file will be the Log file.<\/p>\n<p>When we select the Log option, Filegroup changes to Not Applicable. Because the Log file does not have a file group.<\/p>\n<p>To determine the starting size of the file we will create, we write the value on Initial Size.<\/p>\n<p>In Autogrowth \/ Maxsize, we determine the auto growth value of the log file we will create.<\/p>\n<p>You must be very careful when determining the autogrowth value of the log file for the performance of the database.<\/p>\n<p>You should read the below article for understanding performance affect of the autogrowth value of the log file.<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/06\/09\/vlfvirtual-log-file-count\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlf (Virtual Log File) Count<\/a>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/582.png\" width=\"690\" height=\"223\" \/><\/p>\n<p>Click ok afte all our operations have completed.<\/p>\n<p>If you want the database to use only the second log file instead of the first log file, you can disable the autogrowth of the first log file.<\/p>\n<p>To do this, click &#8220;&#8230;&#8221; next to Autogrowth \/ Maxsize in the first log file and remove selection on &#8220;Enable Autogrowth&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/671.png\" width=\"441\" height=\"362\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_163\" class=\"pvc_stats all  \" data-element-id=\"163\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Why we want to add second log file? It is a process that we usually perform when there is no free space in the disk where the log file exists. By creating a second log file on another disk, we allow the database&#8217;s log operations to continue on new disk. You can find detailed information &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_163\" class=\"pvc_stats all  \" data-element-id=\"163\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":11055,"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":[2896,5137,5135,2899,5134,5133,75,5136,78,76,2894,79,2893,2897,2898,2895,5138,77,2900,5139,80,45],"class_list":["post-163","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-add-an-extra-sql-transaction-log-file","tag-add-another-log-file-sql-server","tag-add-log-file-to-a-database","tag-add-log-file-to-database-sql-server","tag-add-log-files-to-a-database","tag-add-new-log-file-to-sql-database","tag-add-second-log-file","tag-add-second-log-file-sql-server","tag-add-transaction-log","tag-add-transaction-log-file","tag-do-multiple-transaction-logs-help-performance","tag-filegroup","tag-how-do-i-create-a-log-file-in-sql-server","tag-how-to-add-a-log-file-to-a-sql-server-database","tag-i-want-to-create-a-new-transaction-log-file","tag-multiple-transaction-log-file-performance","tag-sql-add-second-log-file","tag-sql-server-transaction-log","tag-sql-server-transaction-log-maximum-file-size","tag-t-sql-add-second-log-file","tag-virtual-lof-file","tag-vlf"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":611,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Add Second Log File To The Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Add Second Log File To The Database\" \/>\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\/06\/how-to-add-second-log-file-to-the-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Add Second Log File To The Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Add Second Log File To The Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-06T19:51:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-31T14:42:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"631\" \/>\n\t<meta property=\"og:image:height\" content=\"390\" \/>\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\/06\/how-to-add-second-log-file-to-the-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Add Second Log File To The Database\",\"datePublished\":\"2018-06-06T19:51:57+00:00\",\"dateModified\":\"2019-10-31T14:42:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/\"},\"wordCount\":522,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png\",\"keywords\":[\"Add an extra SQL Transaction log file\",\"add another log file sql server\",\"Add Log File to a Database\",\"add log file to database sql server\",\"Add Log Files to a Database\",\"Add new log file to SQL database\",\"Add Second Log File\",\"add second log file sql server\",\"Add Transaction Log\",\"Add Transaction Log File\",\"Do multiple transaction logs help performance\",\"Filegroup\",\"How do I create a log file in SQL Server?\",\"How to Add a Log File to a SQL Server Database\",\"I want to create a new Transaction Log file\",\"multiple transaction log file performance\",\"sql add second log file\",\"SQL Server Transaction Log\",\"sql server transaction log maximum file size\",\"t sql add second log file\",\"virtual lof file\",\"vlf\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/\",\"name\":\"How To Add Second Log File To The Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png\",\"datePublished\":\"2018-06-06T19:51:57+00:00\",\"dateModified\":\"2019-10-31T14:42:10+00:00\",\"description\":\"How To Add Second Log File To The Database\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png\",\"width\":631,\"height\":390},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Add Second Log File To The Database\"}]},{\"@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":"How To Add Second Log File To The Database - Database Tutorials","description":"How To Add Second Log File To The Database","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\/06\/how-to-add-second-log-file-to-the-database\/","og_locale":"en_US","og_type":"article","og_title":"How To Add Second Log File To The Database - Database Tutorials","og_description":"How To Add Second Log File To The Database","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-06T19:51:57+00:00","article_modified_time":"2019-10-31T14:42:10+00:00","og_image":[{"width":631,"height":390,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.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\/06\/how-to-add-second-log-file-to-the-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Add Second Log File To The Database","datePublished":"2018-06-06T19:51:57+00:00","dateModified":"2019-10-31T14:42:10+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/"},"wordCount":522,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png","keywords":["Add an extra SQL Transaction log file","add another log file sql server","Add Log File to a Database","add log file to database sql server","Add Log Files to a Database","Add new log file to SQL database","Add Second Log File","add second log file sql server","Add Transaction Log","Add Transaction Log File","Do multiple transaction logs help performance","Filegroup","How do I create a log file in SQL Server?","How to Add a Log File to a SQL Server Database","I want to create a new Transaction Log file","multiple transaction log file performance","sql add second log file","SQL Server Transaction Log","sql server transaction log maximum file size","t sql add second log file","virtual lof file","vlf"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/","name":"How To Add Second Log File To The Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png","datePublished":"2018-06-06T19:51:57+00:00","dateModified":"2019-10-31T14:42:10+00:00","description":"How To Add Second Log File To The Database","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-7.png","width":631,"height":390},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/06\/how-to-add-second-log-file-to-the-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Add Second Log File To The Database"}]},{"@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\/163","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=163"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11055"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}