{"id":95,"date":"2018-05-31T18:01:09","date_gmt":"2018-05-31T18:01:09","guid":{"rendered":"http:\/\/dbtut.com\/?p=95"},"modified":"2019-10-31T14:09:49","modified_gmt":"2019-10-31T14:09:49","slug":"what-is-sql-server-transaction-log","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/","title":{"rendered":"What is SQL Server Transaction Log"},"content":{"rendered":"<p><strong>SQL Server Transaction Log<\/strong> is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions are stored in transaction log file.<\/p>\n<p>Each record in the Transaction Log file has a unique number. This is called LSN (Log Sequence Number). LSN2 is always larger than LSN1. When restoring Transaction Logs, you can see the LSN in the message section.<\/p>\n<p>To understand the architecture of SQL Server you need to understand the importance of the Transaction Log. Each database has at least one transaction log file.<\/p>\n<h3>Multiple Transaction Log files and performance impact?<\/h3>\n<p>More than one transaction log file can be added but only 1 log file is written at the same time.<\/p>\n<p>In other words, creating a transaction log file on a different disk to improve performance is useless.<\/p>\n<p>But sometimes, when there is no space on the disk where the transaction log file is located, we can solve this problem by creating a transaction log file on another disk.<\/p>\n<h3>Where is SQL Server Transaction Log File<\/h3>\n<p>The best way of finding transaction log file size and usage is &#8220;try to shrink&#8221; method in my opinion. I always use this method.<\/p>\n<p>Right click on the database and click Properties. Then click Tasks-&gt;Shrink-&gt;Files<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10974 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-5.png\" alt=\"\" width=\"684\" height=\"118\" \/><\/p>\n<p>Choose Transasction Log File from File Type Section in the below screen. Then you can see the location, size and usage of the Transaction Log File from this screen.<\/p>\n<p>Location: Transaction Log File Path<\/p>\n<p>Currently allocated space: Transaction Log File Size<\/p>\n<p>Available free space: You can see how many percent of transaction log file is used. If available free space is near to %100, you can shrink transaction log file. To shrink the transaction log file you can read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-shrink-sql-server-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Shrink SQL Server Transaction Log<\/a>&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10975 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-6.png\" alt=\"\" width=\"692\" height=\"612\" \/><\/p>\n<h3>Importance of Transaction Log File<\/h3>\n<p lang=\"en-US\">For example, your SQL Server server has encountered an unexpected error and has either been shut down or restarted.<\/p>\n<p lang=\"en-US\">In such a case, SQL Server uses the transaction log file to bring the database into a consistent structure.<\/p>\n<p lang=\"en-US\">SQL Server Engine rolls forward completed transactions with the information it receives from the Transaction Log file, and rolls back incomplete transactions.<\/p>\n<p lang=\"en-US\">This ensures database consistency. I would recommend reading the article called &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/05\/28\/what-is-database-checkpoint\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is\u00a0Database Checkpoint<\/a>&#8221; to understand this process in more detail.<\/p>\n<p>If there is a problem in the database, we can use the transaction log file backups to return the database to the most recent time.<\/p>\n<p>I would recommend reading the &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/05\/26\/what-is-database-recovery-model\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is\u00a0Database Recovery Model<\/a>&#8221; article.<\/p>\n<p>The SQL Server Transaction Log file consists of one or more virtual log files.<\/p>\n<p>These virtual log files can seriously affect performance.<\/p>\n<p>You can find the details of the article named &#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\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_95\" class=\"pvc_stats all  \" data-element-id=\"95\" 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>SQL Server Transaction Log is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions are stored in transaction log file. Each record in the Transaction Log file has a unique number. This is called LSN (Log Sequence Number). LSN2 is always larger than LSN1. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_95\" class=\"pvc_stats all  \" data-element-id=\"95\" 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":10977,"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":[5114,5109,4972,2812,2813,5108,4971,1265,2811,26,4969,5111,4970,5110,4975,77,4980,4968,27,4979,4977,102,4978,4974,5113,46,45,2814,2815,2817,5112,2816,4976,4973],"class_list":["post-95","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-creating-a-transaction-log-file-on-a-different-disk","tag-does-sql-server-write-log-files-in-parallel","tag-find-the-transaction-log","tag-how-do-i-find-the-transaction-log-in-sql-server","tag-how-do-i-find-the-transaction-log-size-in-sql-server","tag-improve-sql-server-performance-by-creating-a-transaction-log","tag-increase-sql-server-performance-by-adding-second-transaction-log-file","tag-ldf-file","tag-log-sequence-number","tag-lsn","tag-lsn-number","tag-multiple-log-files","tag-multiple-transaction-log-files-and-performance-impact","tag-optimizing-transaction-log-throughput","tag-sql-server-ldf-size","tag-sql-server-transaction-log","tag-sql-server-transaction-log-architecture","tag-sql-server-transaction-log-file","tag-transaction-log","tag-transaction-log-available-free-space","tag-transaction-log-currently-allocated-space","tag-transaction-log-file","tag-transaction-log-file-location","tag-transaction-log-file-size","tag-understanding-the-importance-of-transaction-logs-in-sql-server","tag-virtual-log-file","tag-vlf","tag-what-is-a-transaction-log-in-sql-server","tag-what-is-ldf-file-in-sql-server","tag-what-is-log-file-in-database","tag-what-is-the-transaction-log","tag-what-type-of-file-is-a-transaction-log-file","tag-where-is-ldf-file","tag-where-is-sql-server-transaction-log-file"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":836,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is SQL Server Transaction Log - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Server Transaction Log\" \/>\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\/05\/31\/what-is-sql-server-transaction-log\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is SQL Server Transaction Log - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Server Transaction Log\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-31T18:01:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-31T14:09:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"642\" \/>\n\t<meta property=\"og:image:height\" content=\"264\" \/>\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=\"2 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\/05\/31\/what-is-sql-server-transaction-log\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is SQL Server Transaction Log\",\"datePublished\":\"2018-05-31T18:01:09+00:00\",\"dateModified\":\"2019-10-31T14:09:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\"},\"wordCount\":469,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png\",\"keywords\":[\"creating a transaction log file on a different disk\",\"Does SQL Server write log files in parallel\",\"Find the Transaction Log\",\"How do I find the transaction log in SQL Server?\",\"How do I find the transaction log size in SQL Server?\",\"Improve SQL Server performance by creating a transaction log\",\"increase sql server performance by adding second transaction log file\",\"ldf file\",\"Log Sequence Number\",\"LSN\",\"LSN number\",\"Multiple log files\",\"Multiple Transaction Log files and performance impact\",\"Optimizing Transaction Log Throughput\",\"SQL Server ldf size\",\"SQL Server Transaction Log\",\"SQL Server transaction log architecture\",\"SQL Server Transaction Log file\",\"Transaction Log\",\"transaction log available free space\",\"transaction log Currently allocated space\",\"Transaction Log File\",\"transaction log file location\",\"Transaction Log File Size\",\"Understanding the importance of transaction logs in SQL Server\",\"virtual log file\",\"vlf\",\"What is a transaction log in SQL Server?\",\"What is LDF file in SQL Server?\",\"What is log file in database?\",\"What is the transaction log?\",\"What type of file is a transaction log file?\",\"where is ldf file\",\"Where is SQL Server Transaction Log File\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\",\"name\":\"What is SQL Server Transaction Log - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png\",\"datePublished\":\"2018-05-31T18:01:09+00:00\",\"dateModified\":\"2019-10-31T14:09:49+00:00\",\"description\":\"SQL Server Transaction Log\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png\",\"width\":642,\"height\":264},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is SQL Server Transaction Log\"}]},{\"@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":"What is SQL Server Transaction Log - Database Tutorials","description":"SQL Server Transaction Log","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\/05\/31\/what-is-sql-server-transaction-log\/","og_locale":"en_US","og_type":"article","og_title":"What is SQL Server Transaction Log - Database Tutorials","og_description":"SQL Server Transaction Log","og_url":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/","og_site_name":"Database Tutorials","article_published_time":"2018-05-31T18:01:09+00:00","article_modified_time":"2019-10-31T14:09:49+00:00","og_image":[{"width":642,"height":264,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is SQL Server Transaction Log","datePublished":"2018-05-31T18:01:09+00:00","dateModified":"2019-10-31T14:09:49+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/"},"wordCount":469,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png","keywords":["creating a transaction log file on a different disk","Does SQL Server write log files in parallel","Find the Transaction Log","How do I find the transaction log in SQL Server?","How do I find the transaction log size in SQL Server?","Improve SQL Server performance by creating a transaction log","increase sql server performance by adding second transaction log file","ldf file","Log Sequence Number","LSN","LSN number","Multiple log files","Multiple Transaction Log files and performance impact","Optimizing Transaction Log Throughput","SQL Server ldf size","SQL Server Transaction Log","SQL Server transaction log architecture","SQL Server Transaction Log file","Transaction Log","transaction log available free space","transaction log Currently allocated space","Transaction Log File","transaction log file location","Transaction Log File Size","Understanding the importance of transaction logs in SQL Server","virtual log file","vlf","What is a transaction log in SQL Server?","What is LDF file in SQL Server?","What is log file in database?","What is the transaction log?","What type of file is a transaction log file?","where is ldf file","Where is SQL Server Transaction Log File"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/","url":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/","name":"What is SQL Server Transaction Log - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png","datePublished":"2018-05-31T18:01:09+00:00","dateModified":"2019-10-31T14:09:49+00:00","description":"SQL Server Transaction Log","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-7.png","width":642,"height":264},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is SQL Server Transaction Log"}]},{"@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\/95","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=95"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/10977"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}