{"id":4542,"date":"2022-03-14T07:00:00","date_gmt":"2022-03-14T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=4542"},"modified":"2024-03-08T20:04:27","modified_gmt":"2024-03-08T17:04:27","slug":"pos-aytomatopoioyme-tin-diadikasia-backup","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-aytomatopoioyme-tin-diadikasia-backup\/","title":{"rendered":"How do we automate the database backup process in SQL Server without using a maintenance plan"},"content":{"rendered":"<p>In this article we will see the easiest and most efficient way to backup all instance databases. We will do this using the procedure <strong>DatabaseBackup<\/strong> which has been made by <a href=\"https:\/\/ola.hallengren.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Ola Hallengren<\/a>.<\/p>\n\n\n\n<p>Of course, this work is also done with the use <strong>T-SQL<\/strong> (e.g. <strong>backup database<\/strong>) the <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/maintenance-plans\/maintenance-plans?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">maintenance plans<\/a><\/strong> which SQL Server has built-in, but the above has some limitations. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What more does it offer?<\/h3>\n\n\n\n<p>The procedure <strong><strong>DatabaseBackup<\/strong><\/strong> it can perform separate backups in user or system databases, delete old backup files with the same job and many more with the various parameters it accepts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The installation<\/h2>\n\n\n\n<p>Download from here the package with the procedures we will need:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-1de3dfcc-07a8-489e-bc82-e41f2d95deb6\" href=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/MaintenanceSolution.zip\">MaintenanceSolution<\/a><a href=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/MaintenanceSolution.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-1de3dfcc-07a8-489e-bc82-e41f2d95deb6\">Download<\/a><\/div>\n\n\n\n<p>or directly from the creator&#039;s site&nbsp;<a href=\"https:\/\/ola.hallengren.com\/scripts\/MaintenanceSolution.sql\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<p>After it is downloaded, we execute the entire script in the database that we want to call from it, for example in a custom database that we have made for monitoring or in the systemic master database.<\/p>\n\n\n\n<p>Then to start the process, we simply execute the procedure with the parameters as below:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">EXECUTE dbo.DatabaseBackup\n@Databases = 'ALL_DATABASES',\n--@Directory = 'C:\\backup',  --comment for default backup folder\n@BackupType = 'FULL',\n@Verify = 'Y',\n@Compress = 'Y',\n@CheckSum = 'Y',\n@CleanupTime = 360<\/pre>\n\n\n\n<p>What exactly does each parameter define:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>@<strong>Databases<\/strong> we define whether the process will run on all databases, the systemic ones or the ones we have made.<\/li>\n\n\n\n<li>@<strong>Directory<\/strong> we define this specific parameter when we don&#039;t want the backup to take to the default directory but to another one.<\/li>\n\n\n\n<li>@<strong>BackupType<\/strong> we define if it will get FULL \/ DIFFERENTIAL \/ LOG backup.<\/li>\n\n\n\n<li><strong>@Verify<\/strong> we define whether to verify the backup.<\/li>\n\n\n\n<li><strong>@Compress<\/strong> define whether the backup will be compressed.<\/li>\n\n\n\n<li><strong>@CheckSum<\/strong> we define whether to enable CheckSum.<\/li>\n\n\n\n<li><strong>@CleanupTime<\/strong>  we define after how many hours the backups will be deleted.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>There are detailed instructions for each parameter on the creator&#039;s website <a href=\"https:\/\/ola.hallengren.com\/sql-server-backup.html\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How do I automate the process?<\/h2>\n\n\n\n<p>We can add the execution of the procedure to a SQL Server Agent Job.<\/p>\n\n\n\n<p>To do this we go to&nbsp;<em>Objects Explorer<\/em>,&nbsp;<em>SQL Server Agent<\/em>, right click on&nbsp;<em>Jobs<\/em>,&nbsp;<em>New Job<\/em>\u2026<\/p>\n\n\n\n<p>In the window that appears, go to the tab&nbsp;<em>Steps&nbsp;<\/em>and we choose&nbsp;<em>New<\/em>.<\/p>\n\n\n\n<p>There we choose the master database where we had installed the procedure and add the script of the procedure:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_01-1024x364.png\" alt=\"\" class=\"wp-image-4543\" style=\"width:1024px;height:364px\" width=\"1024\" height=\"364\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_01-1024x364.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_01-300x107.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_01-768x273.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_01-1536x545.png 1536w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_01.png 1842w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">01<\/figcaption><\/figure>\n\n\n\n<p>In the tab&nbsp;<em>Schedules&nbsp;<\/em>we can define the frequency that the task will run. It would be good to choose a time that does not have a heavy workload with access to the data in the instance:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"829\" height=\"647\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_02.png\" alt=\"\" class=\"wp-image-4544\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_02.png 829w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_02-300x234.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/02\/dbbh_02-768x599.png 768w\" sizes=\"auto, (max-width: 829px) 100vw, 829px\" \/><figcaption class=\"wp-element-caption\">02<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">To see in detail each action that the procedure has done and when it did it<\/h4>\n\n\n\n<p>We simply make a select in the commandlog table:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select * from master..commandlog;<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Bonus<\/h2>\n\n\n\n<p>With the following script that I have made, with just one click, it installs it <a href=\"https:\/\/ola.hallengren.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">MaintenanceSolution<\/a> by Ola Hallengren along with ready configured jobs for <strong>Backup<\/strong> ,<strong>Database Integrity<\/strong> and <strong>Index Optimize<\/strong> with optimal parameters and timing.<\/p>\n\n\n\n<p>Backup jobs are created <strong>disabled<\/strong> as we may have another solution for backup with a 3rd party tool. It also checks for <strong>Availability Group<\/strong> so that they run only if it is the <em>Preferred Backup Replica <\/em>(for backup \/ database integrity) and if it is <em>Primary Replica<\/em> (for Index Optimize).<\/p>\n\n\n\n<p>All we need to do is run the following script on each SQL Server Instance:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-b409725c-cd9c-42b1-b14d-767c36272025\" href=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/09\/MaintenanceSolution-ReadyToPlay.txt\">MaintenanceSolution-ReadyToPlay<\/a><a href=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/09\/MaintenanceSolution-ReadyToPlay.txt\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-b409725c-cd9c-42b1-b14d-767c36272025\">Download<\/a><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Full Database Backup<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ola.hallengren.com\/sql-server-backup.html\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Backup<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>In this article we will see the easiest and most efficient way to backup all instance databases. We will do this using the DatabaseBackup procedure created by Ola Hallengren. Of course, this work is also done using T-SQL (e.g. backup database) or maintance plans that [...]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15],"tags":[29,66,23,494,30,6],"class_list":["post-4542","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","tag-databases","tag-disaster-recovery","tag-microsoft","tag-ola-hallengren-maintenance-solution","tag-rdbms","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/pos-aytomatopoioyme-tin-diadikasia-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c4\u03bf\u03bd \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf \u03ba\u03b1\u03b9 \u03b1\u03c0\u03bf\u03b4\u03bf\u03c4\u03b9\u03ba\u03cc \u03c4\u03c1\u03cc\u03c0\u03bf \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03c0\u03ac\u03c1\u03bf\u03c5\u03bc\u03b5 backup \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03bf\u03c5 instance. \u0391\u03c5\u03c4\u03cc \u03b8\u03b1 \u03c4\u03bf \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5 \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03b7\u03c2 procedure DatabaseBackup \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03c6\u03c4\u03b9\u03ac\u03be\u03b5\u03b9 \u03bf Ola Hallengren. \u03a6\u03c5\u03c3\u03b9\u03ba\u03ac \u03b1\u03c5\u03c4\u03ae \u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03ba\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 T-SQL (\u03c0.\u03c7. backup database) \u03ae maintance plans \u03c0\u03bf\u03c5 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-aytomatopoioyme-tin-diadikasia-backup\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-14T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-08T17:04:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan\",\"datePublished\":\"2022-03-14T04:00:00+00:00\",\"dateModified\":\"2024-03-08T17:04:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/\"},\"wordCount\":134,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"Databases\",\"Disaster Recovery\",\"Microsoft\",\"Ola Hallengren Maintenance Solution\",\"RDBMS\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2022-03-14T04:00:00+00:00\",\"dateModified\":\"2024-03-08T17:04:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-aytomatopoioyme-tin-diadikasia-backup\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan - DataPlatform.gr","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:\/\/www.dataplatform.gr\/en\/pos-aytomatopoioyme-tin-diadikasia-backup\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan - DataPlatform.gr","og_description":"\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c4\u03bf\u03bd \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf \u03ba\u03b1\u03b9 \u03b1\u03c0\u03bf\u03b4\u03bf\u03c4\u03b9\u03ba\u03cc \u03c4\u03c1\u03cc\u03c0\u03bf \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03c0\u03ac\u03c1\u03bf\u03c5\u03bc\u03b5 backup \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03bf\u03c5 instance. \u0391\u03c5\u03c4\u03cc \u03b8\u03b1 \u03c4\u03bf \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5 \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03b7\u03c2 procedure DatabaseBackup \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03c6\u03c4\u03b9\u03ac\u03be\u03b5\u03b9 \u03bf Ola Hallengren. \u03a6\u03c5\u03c3\u03b9\u03ba\u03ac \u03b1\u03c5\u03c4\u03ae \u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03ba\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 T-SQL (\u03c0.\u03c7. backup database) \u03ae maintance plans \u03c0\u03bf\u03c5 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-aytomatopoioyme-tin-diadikasia-backup\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2022-03-14T04:00:00+00:00","article_modified_time":"2024-03-08T17:04:27+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan","datePublished":"2022-03-14T04:00:00+00:00","dateModified":"2024-03-08T17:04:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/"},"wordCount":134,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["Databases","Disaster Recovery","Microsoft","Ola Hallengren Maintenance Solution","RDBMS","SQL Server"],"articleSection":["Databases","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/","url":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/","name":"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2022-03-14T04:00:00+00:00","dateModified":"2024-03-08T17:04:27+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-aytomatopoioyme-tin-diadikasia-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 backup \u03c4\u03c9\u03bd \u03b2\u03ac\u03c3\u03b5\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 maintenance plan"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/4542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=4542"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/4542\/revisions"}],"predecessor-version":[{"id":5592,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/4542\/revisions\/5592"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=4542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=4542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=4542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}