{"id":38988,"date":"2025-06-03T11:45:28","date_gmt":"2025-06-03T09:45:28","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=38988"},"modified":"2025-06-03T11:45:36","modified_gmt":"2025-06-03T09:45:36","slug":"guidance-for-a-sql-server-backup-strategy-in-aws-ec2","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/","title":{"rendered":"Guidance for a SQL Server backup strategy in AWS EC2"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-introduction\">INTRODUCTION<\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.aws.amazon.com\/AmazonS3\/latest\/userguide\/DataDurability.html\">S3 storage<\/a> is the most resilient and available service in AWS: is a trusted service for storing backups over the long term.<\/p>\n\n\n\n<p>From a Windows Server machine, in AWS EC2 or elsewhere, the easiest and most reliable way to make a backup from SQL Server:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Via URL, <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/sql-server-backup-and-restore-with-s3-compatible-object-storage?view=sql-server-ver17\">natively supported<\/a> since SQL Server 2022<\/li>\n\n\n\n<li>Via a <a href=\"https:\/\/docs.aws.amazon.com\/filegateway\/latest\/files3\/file-gateway-concepts.html\">Storage Gateway with File Gateway<\/a>, which exposes an SMB share. The Storage Gateway will be responsible for replication to S3<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-concept\">1- Concept<\/h2>\n\n\n\n<p>For data that must be available over a long period of time (finance, insurance, medical), less costly archiving can be envisaged as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>By optimizing the type of <a href=\"https:\/\/docs.aws.amazon.com\/AmazonS3\/latest\/userguide\/storage-class-intro.html\">storage class<\/a><\/li>\n\n\n\n<li>Reduce the volume of backups with a retention strategy<\/li>\n<\/ul>\n\n\n\n<div style=\"height:4px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-backup-retention\">a- Backup Retention<\/h3>\n\n\n\n<p>For a customer project, we chose to implement the following strategy:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>All backups with 30 days retention (with standard storage class)<\/li>\n\n\n\n<li>A Full backup a month with 12 months retention (with glacier storage class)<\/li>\n\n\n\n<li>A Full backup a year with 15 years retention (with deep-archive storage class)<\/li>\n<\/ul>\n\n\n\n<p>To do this, we decided to create, in a Bucket, the following 3 Prefixes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Daily: contains all backups (.bak, .trn\u2026) in last 30 days<\/li>\n\n\n\n<li>Monthly: contains the first FULL backup of the month in the last 12 months<\/li>\n\n\n\n<li>Yearly: contains the first FULL backup of the year in the last 15 years<\/li>\n<\/ul>\n\n\n\n<div style=\"height:4px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-b-s3-lifecycle-policy\">b- S3 Lifecycle Policy<\/h3>\n\n\n\n<p>To implement the retention, we did set up a <a href=\"https:\/\/docs.aws.amazon.com\/AmazonS3\/latest\/userguide\/object-lifecycle-mgmt.html\">lifecycle rule<\/a> on each 3 prefixes.<br>These rules include the following parameters:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A <strong>Transition Action<\/strong>: the object is converted into the default storage class for the prefix, based on the backup retention decided above. Of course, it&#8217;s more efficient to create them in the right storage class first<\/li>\n\n\n\n<li>A <strong>Retention Action<\/strong>: the object is deleted after a defined period<\/li>\n<\/ul>\n\n\n\n<div style=\"height:4px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-c-archiving-backups\">c- Archiving backups<\/h3>\n\n\n\n<p>While lifecycle exists natively in S3 with Lifecycle Policies, there is no native mechanism which moves S3 objects between prefixes.<br>Generating a backup once a month and\/or a year from SQL Server to S3 is not efficient since backups are already present in Daily prefixes.<br>To do this, you need to set up a custom script which will archive backups from Daily to Monthly and Yearly.<\/p>\n\n\n\n<p>This script can be scheduled, for example, by AWS Lambda or another scheduler tool.<br>In our context, we did choose SQL Server Agent to schedule the archiving after the backup step in a job for the following reasons:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Execute archiving as soon as a new backup (if eligible) was generated<\/li>\n\n\n\n<li>Get access easily and modify it, if necessary, from the database server. Of course, the script is server and instance agnostic\u2026 but you may want to temporarily modify it on a server as a workaround<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-implementation\">2- Implementation<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-accessing-s3\">a- Accessing S3<\/h3>\n\n\n\n<p>First, a <a href=\"https:\/\/aws.amazon.com\/blogs\/security\/how-to-restrict-amazon-s3-bucket-access-to-a-specific-iam-role\/\">IAM role<\/a> must be attached to the EC2 instance to authorize the access to the S3 Bucket where backups are stored. Keep in mind this access is available at the machine level, that&#8217;s why I recommend to restrict access to read\/write only.<br>This role is accessible, on the OS, through a metadata token as follows (<a href=\"https:\/\/docs.aws.amazon.com\/AWSEC2\/latest\/UserGuide\/configuring-instance-metadata-service.html\">IMDSv2 requirement<\/a>):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;string]$token = Invoke-RestMethod -Headers @{\"X-aws-ec2-metadata-token-ttl-seconds\" = \"21600\"} -Method PUT -Uri http:\/\/169.254.169.254\/latest\/api\/token\n# This sens a PUT request to get a token valid for 6 hours<\/code><\/pre>\n\n\n\n<p>Once the token retrieved, you can securely accessed the role assigned the the EC2 instance:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$roleName = Invoke-RestMethod -Uri \"http:\/\/169.254.169.254\/latest\/meta-data\/iam\/security-credentials\/\" -Headers @{\"X-aws-ec2-metadata-token\"=$token}<\/code><\/pre>\n\n\n\n<p>From there, you can get temporary security AWS credentials for this role:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$credentials = Invoke-RestMethod -Uri \"http:\/\/169.254.169.254\/latest\/meta-data\/iam\/security-credentials\/$roleName\" -Headers @{\"X-aws-ec2-metadata-token\"=$token}<\/code><\/pre>\n\n\n\n<p>Then, you can set the credentials using <a href=\"https:\/\/docs.aws.amazon.com\/powershell\/v4\/userguide\/pstools-getting-set-up-windows.html\">AWS Tools PowerShell module<\/a>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Set-AWSCredential -AccessKey $credentials.AccessKeyId -SecretKey $credentials.SecretAccessKey -SessionToken $credentials.Token\n# Credentials set for the current PowerShell session<\/code><\/pre>\n\n\n\n<div style=\"height:4px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-b-retrieving-backups-to-archive\">b- Retrieving backups to archive<\/h3>\n\n\n\n<p>Using <a href=\"https:\/\/dbatools.io\/\">dbatools <\/a>PowerShell module, we retrieve the first backup based on a reference date.<br>Here is an example when a Storage Gateway with File Gateway is used as a destination:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># $RefDate = New-Object DateTime( $Today.Year, $Today.Month, 1 ); # First backup of the month\n# $RefDate = New-Object DateTime( $Today.Year, 1, 1 ); # First backup of the year\n\n$BackupHistory = Get-DbaDBBackupHistory -SqlInstance $ConnectionString -Since $RefDate -Type Full -DeviceType Disk | Group-Object Database;\n\nforeach ($Database in $BackupHistory){\n      $Backup = ($Database.Group | Sort-Object End)&#091;0];\n      $Files = $Backup.Path;\n      foreach ($File in $Files){\n            # Process your copy\n      }\n}<\/code><\/pre>\n\n\n\n<div style=\"height:4px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-c-archiving-backups-0\">c- Archiving backups<\/h3>\n\n\n\n<p>To process the copy, we must construct the key location and the key destination in S3 based on the information retrieved in msdb.<br>So, it mainly depends on your prefix structure in your bucket ; which must remains the same over the time.<br>Here is an example when the structure is <em>RetentionPeriod\\InstanceFolder\\DatabaseName\\FileName<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Process copy for each file\n$Leaf = Split-Path -Path $File -Leaf;\n\n# Construct Source Key in S3\n$SourceKey = \"$($RefSource)\/$($InstanceFolder)\/$($Backup.Database)\/$($Leaf)\";\n\n# Construct Destination Key in S3\n$DestinationKey = \"$($RefDestination)\/$($InstanceFolder)\/$($Backup.Database)\/$($Leaf)\";\n\n# Copy the backup to the new Prefix\nCopy-S3Object -BucketName $bucketName -Key $SourceKey -DestinationKey $DestinationKey -StorageClass $StorageClass -Region $Region;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">CONCLUSION<\/h2>\n\n\n\n<p>In this blog, we demystified all the concepts and steps required to implement a backup strategy in AWS EC2 for SQL Server.<br>For other RDBMS running in EC2, the approach and code used for archiving would be very similar.<\/p>\n\n\n\n<p>If you restrict access to Storage Gateway with File Gateway with READ\/WRITE permissions and you enable COMPRESSION in SQL Server, then I recommend you read this blog I wrote:<br><a href=\"https:\/\/www.dbi-services.com\/blog\/random-permission-denied-when-backing-up-sql-server-databases-to-aws-storage-gateway\/\">Random permission denied when backing up SQL Server databases to AWS Storage Gateway<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>INTRODUCTION S3 storage is the most resilient and available service in AWS: is a trusted service for storing backups over the long term. From a Windows Server machine, in AWS EC2 or elsewhere, the easiest and most reliable way to make a backup from SQL Server: 1- Concept For data that must be available over [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1865,229,198],"tags":[133,51],"type_dbi":[],"class_list":["post-38988","post","type-post","status-publish","format-standard","hentry","category-aws","category-database-administration-monitoring","category-database-management","tag-aws","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Guidance for a SQL Server backup strategy in AWS EC2 - dbi Blog<\/title>\n<meta name=\"description\" content=\"In this blog, we will explore how to implement a good backup strategy for SQL Server running in AWS EC2.\" \/>\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.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guidance for a SQL Server backup strategy in AWS EC2\" \/>\n<meta property=\"og:description\" content=\"In this blog, we will explore how to implement a good backup strategy for SQL Server running in AWS EC2.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-03T09:45:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-03T09:45:36+00:00\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\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.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Guidance for a SQL Server backup strategy in AWS EC2\",\"datePublished\":\"2025-06-03T09:45:28+00:00\",\"dateModified\":\"2025-06-03T09:45:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/\"},\"wordCount\":727,\"commentCount\":0,\"keywords\":[\"AWS\",\"SQL Server\"],\"articleSection\":[\"AWS\",\"Database Administration &amp; Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/\",\"name\":\"Guidance for a SQL Server backup strategy in AWS EC2 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2025-06-03T09:45:28+00:00\",\"dateModified\":\"2025-06-03T09:45:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"In this blog, we will explore how to implement a good backup strategy for SQL Server running in AWS EC2.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guidance for a SQL Server backup strategy in AWS EC2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \\\/ Banking, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/nathan-courtine\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Guidance for a SQL Server backup strategy in AWS EC2 - dbi Blog","description":"In this blog, we will explore how to implement a good backup strategy for SQL Server running in AWS EC2.","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.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/","og_locale":"en_US","og_type":"article","og_title":"Guidance for a SQL Server backup strategy in AWS EC2","og_description":"In this blog, we will explore how to implement a good backup strategy for SQL Server running in AWS EC2.","og_url":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/","og_site_name":"dbi Blog","article_published_time":"2025-06-03T09:45:28+00:00","article_modified_time":"2025-06-03T09:45:36+00:00","author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Guidance for a SQL Server backup strategy in AWS EC2","datePublished":"2025-06-03T09:45:28+00:00","dateModified":"2025-06-03T09:45:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/"},"wordCount":727,"commentCount":0,"keywords":["AWS","SQL Server"],"articleSection":["AWS","Database Administration &amp; Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/","url":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/","name":"Guidance for a SQL Server backup strategy in AWS EC2 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-06-03T09:45:28+00:00","dateModified":"2025-06-03T09:45:36+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"In this blog, we will explore how to implement a good backup strategy for SQL Server running in AWS EC2.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/guidance-for-a-sql-server-backup-strategy-in-aws-ec2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Guidance for a SQL Server backup strategy in AWS EC2"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=38988"}],"version-history":[{"count":29,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38988\/revisions"}],"predecessor-version":[{"id":41601,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38988\/revisions\/41601"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=38988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=38988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=38988"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=38988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}