{"id":7328,"date":"2019-01-07T08:39:40","date_gmt":"2019-01-07T08:39:40","guid":{"rendered":"https:\/\/dbtut.com\/?p=7328"},"modified":"2019-04-15T12:43:44","modified_gmt":"2019-04-15T12:43:44","slug":"how-to-create-log-backup-using-sql-server-maintenance-plan","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/","title":{"rendered":"How To Create Log Backup Using SQL Server Maintenance Plan"},"content":{"rendered":"<p>We perform maintenance operations in SQL Server using Maintenance Plan. In this article we will create a maintenance plan for Log Backup. I will share article links of other processes that can be performed using SQL Server Maintenance Plan at the end of the article.<\/p>\n<p>From the Management tab under SSMS, we select Maintenance Plans and Maintenance Plan Wizard as shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/267-1.png\" width=\"375\" height=\"78\" \/><\/p>\n<p>On the next screen, select &#8220;Do not show this starting page again&#8221; as follows and click Next.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/445.png\" width=\"560\" height=\"494\" \/><\/p>\n<p>We give a name to the Maintenance Plan from the Name section as follows on the incoming screen.\u00a0 I named LogBackup.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/349.png\" width=\"554\" height=\"491\" \/><\/p>\n<p>Then click Change in the Schedule section. A screen appears as follows.<\/p>\n<p>From Occurs you can choose Daily, Weekly or Monthly.<\/p>\n<ul>\n<li>Select Daily if you want this maintenance plan to run daily<\/li>\n<li>Select Weekly if you want this maintenance plan to run weekly<\/li>\n<li>Select Monthly if you want this maintenance plan to run monthly<\/li>\n<\/ul>\n<p>We schedule the job like below in the Schedule section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/255.png\" width=\"595\" height=\"500\" \/><\/p>\n<p>On the next screen, we select Back Up Database(Transaction Log) as follows and click next.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/690.png\" width=\"595\" height=\"525\" \/><\/p>\n<p>When we click &#8220;Select one or more&#8221; in the Databases section, the window appears just below.<\/p>\n<p>If we select the All databases option, it will create log backup of all databases.<\/p>\n<p>If we select System databases, it will create log backup of system databases.<\/p>\n<p>If we select All user databases, it will create log backup of all user databases.<\/p>\n<p>We can select specific databases by selecting these databases. For example, in this example we will only create log Backup of the Test database as follows.<\/p>\n<p>If you select &#8220;Ignore databases is not online&#8221; option and a database is inaccessible during the backup process, it continues for the next database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/385.png\" width=\"619\" height=\"621\" \/><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">In the next screen, if you select &#8220;Write a report to a text file&#8221; as below, it will create a report in the folder you selected in Folder location.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">If you select the E-mail report option, it will send the reports to the e-mail address you specified in the To: section.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">Since I have no operator defined on my server, I got an error like the following.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><span style=\"color: #ff0000;\"><em>There are no operators defined on the system.<\/em><\/span><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">You may want to read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/08\/how-to-create-an-operator-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create An Operator On SQL Server<\/a>&#8221; to get detailed information about the operator. Finish the process by clicking Next and Finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/501.png\" width=\"600\" height=\"535\" \/><\/p>\n<p>You can find more articles about Maintenance Plans below.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/03\/reorganizing-indexes-using-sql-server-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Reorganizing Indexes Using Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/04\/rebuilding-indexes-using-sql-server-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Rebuilding Indexes Using SQL Server Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/how-to-create-full-backup-using-sql-server-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create Full Backup Using SQL Server Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/get-differential-backup-using-sql-server-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create Differential Backup Using SQL Server Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/08\/checking-database-consistency-using-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Checking Database Consistency Using Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/09\/updating-statistics-using-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Updating Statistics Using Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/10\/deleting-maintenance-plan-history\/\" target=\"_blank\" rel=\"noopener noreferrer\">Deleting Backup, Restore, Job, or Maintenance Plan History Using Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/running-an-existing-job-using-maintenance-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Running an Existing Job Using Maintenance Plan<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/12\/deleting-files-with-a-specified-extension-in-a-folder-using-maintenance-planmaintenance-cleanup-task\/\" target=\"_blank\" rel=\"noopener noreferrer\">Deleting Files with a Specified Extension in a Folder Using\u00a0 Maintenance Plan(Maintenance Cleanup Task)<\/a>&#8221;<\/p>\n<p>To understand What is Transaction log and why we should backup it, read the following articles.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/31\/what-is-sql-server-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is SQL Server Transaction Log&#8221;<\/a>,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/26\/what-is-database-recovery-model\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Database Recovery Model<\/a>&#8221;<\/p>\n<p>You may want to read the below article to restore your backups.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/backup-restore-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Backup Restore On SQL Server<\/a>&#8221;<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7328\" class=\"pvc_stats all  \" data-element-id=\"7328\" 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>We perform maintenance operations in SQL Server using Maintenance Plan. In this article we will create a maintenance plan for Log Backup. I will share article links of other processes that can be performed using SQL Server Maintenance Plan at the end of the article. From the Management tab under SSMS, we select Maintenance Plans &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7328\" class=\"pvc_stats all  \" data-element-id=\"7328\" 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":11612,"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":[3405,3404,3408,3403,3413,3421,3409,3397,3423,3411,3412,3415,3416,3417,3418,3419,3420,3422,3410,3406,3407],"class_list":["post-7328","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-backup-job-for-sql-server-transaction-log","tag-backup-sql-server-log-regularly","tag-backup-using-sql-server-maintenance-plans","tag-create-a-job-for-backing-up-sql-server-log","tag-how-do-i-automate-backup-and-restore-in-sql-server","tag-how-do-i-automatically-backup-sql-database","tag-how-do-i-automatically-backup-sql-server-database","tag-how-do-i-backup-a-sql-log-file","tag-how-do-i-backup-all-sql-server-databases","tag-how-do-i-backup-my-ssms-database","tag-how-do-i-backup-sql-job","tag-how-do-i-create-a-backup-file-in-sql-server","tag-how-do-i-create-a-backup-job-in-sql-server-2012","tag-how-do-i-create-a-backup-job-in-sql-server-2014","tag-how-do-i-create-a-backup-job-in-sql-server-2016","tag-how-do-i-create-a-backup-job-in-sql-server-2017","tag-how-do-i-create-a-backup-job-in-sql-server-2019","tag-how-do-i-schedule-a-backup-in-sql-server","tag-how-do-i-schedule-a-sql-backup","tag-how-to-take-sql-server-database-backup-automatically","tag-sql-server-transaction-log-backup-script"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create Log Backup Using SQL Server Maintenance Plan - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Get Log Backup Using SQL Server Maintenance Plan\" \/>\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\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Log Backup Using SQL Server Maintenance Plan - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Get Log Backup Using SQL Server Maintenance Plan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-07T08:39:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-15T12:43:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"557\" \/>\n\t<meta property=\"og:image:height\" content=\"369\" \/>\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\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Create Log Backup Using SQL Server Maintenance Plan\",\"datePublished\":\"2019-01-07T08:39:40+00:00\",\"dateModified\":\"2019-04-15T12:43:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\"},\"wordCount\":536,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png\",\"keywords\":[\"backup job for sql server transaction log\",\"backup sql server log regularly\",\"backup using sql server maintenance plans\",\"create a job for backing up sql server log\",\"How do I automate backup and restore in SQL Server?\",\"How do I automatically backup SQL database?\",\"How do I automatically backup SQL Server database?\",\"How do I backup a SQL log file?\",\"How do I backup all SQL Server databases?\",\"How do I backup my SSMS database?\",\"How do I backup SQL job?\",\"How do I create a backup file in SQL Server?\",\"How do I create a backup job in SQL Server 2012?\",\"How do I create a backup job in SQL Server 2014?\",\"How do I create a backup job in SQL Server 2016?\",\"How do I create a backup job in SQL Server 2017?\",\"How do I create a backup job in SQL Server 2019?\",\"How do I schedule a backup in SQL Server\",\"How do I schedule a SQL backup?\",\"how to take sql server database backup automatically\",\"sql server transaction log backup script\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\",\"name\":\"How To Create Log Backup Using SQL Server Maintenance Plan - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png\",\"datePublished\":\"2019-01-07T08:39:40+00:00\",\"dateModified\":\"2019-04-15T12:43:44+00:00\",\"description\":\"Get Log Backup Using SQL Server Maintenance Plan\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png\",\"width\":557,\"height\":369},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Log Backup Using SQL Server Maintenance Plan\"}]},{\"@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 Create Log Backup Using SQL Server Maintenance Plan - Database Tutorials","description":"Get Log Backup Using SQL Server Maintenance Plan","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\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/","og_locale":"en_US","og_type":"article","og_title":"How To Create Log Backup Using SQL Server Maintenance Plan - Database Tutorials","og_description":"Get Log Backup Using SQL Server Maintenance Plan","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-07T08:39:40+00:00","article_modified_time":"2019-04-15T12:43:44+00:00","og_image":[{"width":557,"height":369,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.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\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Create Log Backup Using SQL Server Maintenance Plan","datePublished":"2019-01-07T08:39:40+00:00","dateModified":"2019-04-15T12:43:44+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/"},"wordCount":536,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png","keywords":["backup job for sql server transaction log","backup sql server log regularly","backup using sql server maintenance plans","create a job for backing up sql server log","How do I automate backup and restore in SQL Server?","How do I automatically backup SQL database?","How do I automatically backup SQL Server database?","How do I backup a SQL log file?","How do I backup all SQL Server databases?","How do I backup my SSMS database?","How do I backup SQL job?","How do I create a backup file in SQL Server?","How do I create a backup job in SQL Server 2012?","How do I create a backup job in SQL Server 2014?","How do I create a backup job in SQL Server 2016?","How do I create a backup job in SQL Server 2017?","How do I create a backup job in SQL Server 2019?","How do I schedule a backup in SQL Server","How do I schedule a SQL backup?","how to take sql server database backup automatically","sql server transaction log backup script"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/","name":"How To Create Log Backup Using SQL Server Maintenance Plan - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png","datePublished":"2019-01-07T08:39:40+00:00","dateModified":"2019-04-15T12:43:44+00:00","description":"Get Log Backup Using SQL Server Maintenance Plan","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/Ads\u0131z-2.png","width":557,"height":369},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/how-to-create-log-backup-using-sql-server-maintenance-plan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create Log Backup Using SQL Server Maintenance Plan"}]},{"@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\/7328","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=7328"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7328\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11612"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}