{"id":538,"date":"2022-05-28T15:30:00","date_gmt":"2022-05-28T18:30:00","guid":{"rendered":"https:\/\/ederlelis.com.br\/blog\/?p=538"},"modified":"2022-05-28T16:28:44","modified_gmt":"2022-05-28T19:28:44","slug":"automatizar_backups_armazenando_em_blob_no_azure","status":"publish","type":"post","link":"https:\/\/ederlelis.com.br\/blog\/automatizar_backups_armazenando_em_blob_no_azure\/","title":{"rendered":"Automatizar Backups Armazenando em Blob &#8211; Azure usando Microsoft SSMS"},"content":{"rendered":"<p><span>Ol\u00e1, espero que voc\u00ea esteja bem!\u00a0<\/span><img draggable=\"false\" role=\"img\" class=\"emoji\" alt=\"\ud83d\ude09\" src=\"https:\/\/s.w.org\/images\/core\/emoji\/13.1.0\/svg\/1f609.svg\" \/><\/p>\n<p>Algumas pessoas me pediram para dar continua\u00e7\u00e3o no assunto de <strong>Backups para o Azure<\/strong>, da\u00ed resolvi escrever este Post, e espero ser bem \u00fatil. Vou dividir ele em duas partes, que vou chamar de <strong>&#8220;automatiza\u00e7\u00e3o de backup&#8221;<\/strong> e <strong>&#8220;backups avulsos&#8221;<\/strong>. Portanto se o assunto te agrada, continue aqui e bora para mais um conhecimento bacana!<\/p>\n<p>Para aqueles que querem <strong>criar um Job de Backup e automatizar<\/strong> o trabalho pensando principalmente em seguran\u00e7a, afinal, se um dia algo acontecer com meu banco de dados, ser\u00e1 que est\u00e1 preparado? Quanto &#8220;tempo de dados&#8221; posso perder?<\/p>\n<p><\/p>\n<p><em>Pause par<\/em><em>a momento merchandising&#8230; rsrs!<\/em><\/p>\n<p>Sou Consultor DBA SQL Server na Power Tuning. \u00c9 uma Empresa de Consultoria a qual tamb\u00e9m pode te ajudar n\u00e3o s\u00f3 com esta quest\u00e3o de automatizar backups, e sim muito mais&#8230; D\u00ea uma olhadinha no site e qualquer d\u00favida, s\u00f3 entrar em contato por l\u00e1 mesmo. <a href=\"https:\/\/powertuning.com.br\/\" target=\"_blank\" rel=\"noopener\">Power Tuning \u2013 Liberte o poder dos seus dados!<\/a><\/p>\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-default\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=309%2C69&#038;ssl=1\" alt=\"\" class=\"wp-image-680\" width=\"309\" height=\"69\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?w=898&amp;ssl=1 898w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=300%2C67&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=768%2C171&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=700%2C156&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=520%2C116&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=360%2C80&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=250%2C56&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/logo-power.png?resize=100%2C22&amp;ssl=1 100w\" sizes=\"(max-width: 309px) 100vw, 309px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Voltando pra c\u00e1!<\/p>\n<p><strong>1) Automatiza\u00e7\u00e3o de backup<\/strong><\/p>\n<p>Para criarmos um job de backup vou usar os scripts do <a href=\"https:\/\/ola.hallengren.com\/\" target=\"_blank\" rel=\"noopener\">OlaHallengren<\/a>, devido ter uma licen\u00e7a de c\u00f3digo aberto popular e amplamente utilizada. Podendo ser usado em Microsoft SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 e SQL Server 2019.<\/p>\n<p>Vamos iniciar fazendo o download do <a href=\"https:\/\/ola.hallengren.com\/scripts\/MaintenanceSolution.sql\" target=\"_blank\" rel=\"noopener\">MaintenanceSolution.sql<\/a>. Este script vai ser usado para criar todos os objetos e trabalhos que vamos precisar.<\/p>\n<p>Para mais detalhes sobre o script que voc\u00ea acabou de baixar, segue links do site:<\/p>\n<p><a href=\"https:\/\/ola.hallengren.com\/sql-server-backup.html\" target=\"_blank\" rel=\"noopener\"><strong>Backup do banco de dados:<\/strong><\/a> backup do servidor SQL<br><a href=\"https:\/\/ola.hallengren.com\/sql-server-integrity-check.html\" target=\"_blank\" rel=\"noopener\">DatabaseIntegrityCheck:<\/a> SQL Server Integrity Check<br><a href=\"https:\/\/ola.hallengren.com\/sql-server-index-and-statistics-maintenance.html\" target=\"_blank\" rel=\"noopener\">IndexOtimize:<\/a> SqL Server Index and Statistics Maintenance<\/p>\n<p>Portanto depois de abrir o script em seu Management Studio (SSMS), basta dar <strong>F5<\/strong>.<\/p>\n<p>Observa (no lado direito) que \u00e9 <strong>instalado por default na database Master.<\/strong> Alguns par\u00e2metros est\u00e3o previamente definidos, mas podem ser alterados depois caso queira.<\/p>\n<p>Do lado esquerdo mostra as <strong>Procedures<\/strong> que foram criadas.<\/p>\n\n\n<figure class=\"wp-block-image alignwide size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"263\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=640%2C263&#038;ssl=1\" alt=\"\" class=\"wp-image-563\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?w=1176&amp;ssl=1 1176w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=300%2C123&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=1024%2C421&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=768%2C316&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=700%2C288&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=520%2C214&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=360%2C148&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=250%2C103&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/01.jpg?resize=100%2C41&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pronto, os Jobs tamb\u00e9m foram criados.<\/p>\n<ul>\n<li><strong>Job de Backup FULL<\/strong> (para as bases do sistema: model, master, msdb)<\/li>\n<li><strong>Job de Backup DIFF<\/strong><\/li>\n<li><strong>Job de Backup FULL<\/strong><\/li>\n<li><strong>Job de Backup LOG<\/strong>&nbsp;<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-default\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/2.png?resize=379%2C233&#038;ssl=1\" alt=\"\" class=\"wp-image-583\" width=\"379\" height=\"233\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/2.png?w=360&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/2.png?resize=300%2C184&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/2.png?resize=250%2C153&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/2.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 379px) 100vw, 379px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Agora vamos editar algumas propriedades do Job <strong>DatabaseBackup &#8211; USER_DATABASES &#8211; FULL<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"387\" height=\"380\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_1.png?resize=387%2C380&#038;ssl=1\" alt=\"\" class=\"wp-image-588\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_1.png?w=387&amp;ssl=1 387w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_1.png?resize=300%2C295&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_1.png?resize=360%2C353&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_1.png?resize=250%2C245&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_1.png?resize=100%2C98&amp;ssl=1 100w\" sizes=\"(max-width: 387px) 100vw, 387px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos editar o step do Job.<\/p>\n<p>Para este nosso lab de hoje <strong>vamos usar apenas uma database<\/strong>, no caso a database AdventureWorks2014, portanto basta alterar esse par\u00e2metro.<\/p>\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"374\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=640%2C374&#038;ssl=1\" alt=\"\" class=\"wp-image-666\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=1024%2C598&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=300%2C175&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=768%2C448&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=700%2C408&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=520%2C303&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=360%2C210&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=250%2C146&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?resize=100%2C58&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3-2.png?w=1251&amp;ssl=1 1251w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Mas caso queira fazer o backup de mais de uma database, ou todas as databases exceto uma espec\u00edfica, ou outras op\u00e7\u00f5es, veja mais detalhes no pr\u00f3prio site do <a href=\"https:\/\/ola.hallengren.com\/sql-server-backup.html\" target=\"_blank\" rel=\"noopener\">OlaHallengren<\/a>.<\/p>\n\n\n<figure class=\"wp-block-image alignwide size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"428\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=640%2C428&#038;ssl=1\" alt=\"\" class=\"wp-image-590\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?w=982&amp;ssl=1 982w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=300%2C201&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=768%2C514&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=700%2C468&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=520%2C348&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=360%2C241&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=250%2C167&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/3_2.png?resize=100%2C67&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Veja que al\u00e9m de especificar a database que faremos o <strong>backup FULL<\/strong>, tamb\u00e9m especifiquei o diret\u00f3rio onde vamos salvar nossos backups, que no caso ser\u00e1 em um <strong>blob no Azure<\/strong>. Feito as altera\u00e7\u00f5es basta clicar no <strong><em>OK<\/em> <\/strong>para salvar as mudan\u00e7as.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"640\" height=\"362\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?resize=640%2C362&#038;ssl=1\" alt=\"\" class=\"wp-image-589\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?w=695&amp;ssl=1 695w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?resize=520%2C294&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?resize=360%2C204&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?resize=250%2C141&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/4.png?resize=100%2C57&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos agora executar o Job <strong>manualmente<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"385\" height=\"355\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/5.png?resize=385%2C355&#038;ssl=1\" alt=\"\" class=\"wp-image-595\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/5.png?w=385&amp;ssl=1 385w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/5.png?resize=300%2C277&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/5.png?resize=360%2C332&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/5.png?resize=250%2C231&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/5.png?resize=100%2C92&amp;ssl=1 100w\" sizes=\"(max-width: 385px) 100vw, 385px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"380\" height=\"243\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/6.png?resize=380%2C243&#038;ssl=1\" alt=\"\" class=\"wp-image-597\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/6.png?w=380&amp;ssl=1 380w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/6.png?resize=300%2C192&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/6.png?resize=360%2C230&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/6.png?resize=250%2C160&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/6.png?resize=100%2C64&amp;ssl=1 100w\" sizes=\"(max-width: 380px) 100vw, 380px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Num \u00e9 que deu erro, e agora? Veja como est\u00e1 f\u00e1cil de analisar o motivo do erro! \ud83d\ude42<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"564\" height=\"631\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?resize=564%2C631&#038;ssl=1\" alt=\"\" class=\"wp-image-667\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?w=564&amp;ssl=1 564w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?resize=268%2C300&amp;ssl=1 268w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?resize=520%2C582&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?resize=360%2C403&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?resize=250%2C280&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/7-1.png?resize=100%2C112&amp;ssl=1 100w\" sizes=\"(max-width: 564px) 100vw, 564px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Segue abaixo a mensagem de erro reportada no Job, pois em texto talvez fique mais f\u00e1cil localizar o erro.<\/p>\n<pre class=\"height-set:true height:200 width-set:true width:550 wrap:true scroll:true lang:tsql decode:true\">Job Name\t\tDatabaseBackup - USER_DATABASES - FULL\nStep Name\t\tDatabaseBackup - USER_DATABASES - FULL\nDuration\t\t00:00:10\nSql Severity\t16\nSql Message ID\t50000\nOperator Emailed\t\nOperator Net sent\t\nOperator Paged\t\nRetries Attempted\t0\n\nMessage\nExecuted as user: NT SERVICE\\SQLSERVERAGENT. Date and time: 2022-05-19 16:52:22 [SQLSTATE 01000] (Message 50000)  Server: DESKTOP-PKXD [SQLSTATE 01000] (Message 50000)  Version: 15.0.4198.2 [SQLSTATE 01000] (Message 50000)  Edition: Developer Edition (64-bit) [SQLSTATE 01000] (Message 50000)  Platform: Windows [SQLSTATE 01000] (Message 50000)  Procedure: [master].[dbo].[DatabaseBackup] [SQLSTATE 01000] (Message 50000)  Parameters: @Databases = 'AdventureWorks2014', @Directory = 'https:\/\/labsbkp.blob.core.windows.net\/backup\/FULL\/', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = NULL, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @MinBackupSizeForMultipleFiles = NULL, @MaxFileSize = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @FileName = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${AvailabilityGroupName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @FileExtensionFull = NULL, @FileExtensionDiff = NULL, @FileExtensionLog = NULL, @Init = 'N', @Format = 'N', @ObjectLevelRecoveryMap = 'N', @ExcludeLogShippedFromLogBackup = 'Y', @DirectoryCheck = 'Y', ...  Version: 2022-01-02 13:58:13 [SQLSTATE 01000] (Message 50000)  Source: https:\/\/ola.hallengren.com [SQLSTATE 01000] (Message 50000)  \t [SQLSTATE 01000] (Message 50000)  The value for the parameter @Directory is not supported. [SQLSTATE 42000] (Error 50000)  \t [SQLSTATE 01000] (Message 50000)  The documentation is available at https:\/\/ola.hallengren.com\/sql-server-backup.html. [SQLSTATE 42000] (Error 50000)  \t [SQLSTATE 01000] (Message 50000)  Date and time: 2022-05-19 16:52:26 [SQLSTATE 01000] (Message 50000)  \t [SQLSTATE 01000] (Message 50000).  The step failed.\n<\/pre>\n<p><\/p>\n<p><strong>Agora vou ensinar algo que j\u00e1 me salvou nas an\u00e1lises de muitas falhas de job<\/strong>, digamos que ser\u00e1 um B\u00d4NUS! rsrs<\/p>\n<p>Nem sempre as mensagens que vemos nas falhas dos Jobs no SSMS s\u00e3o completas, ou seja, algumas vezes digamos que &#8220;<em>falta algum peda\u00e7o&#8221;<\/em>, mostra incompleta, e fica ent\u00e3o dif\u00edcil entender o motivo da falha. Sendo assim, uma boa pr\u00e1tica \u00e9 colocar para ap\u00f3s cada execu\u00e7\u00e3o do Job, salvar uma mensagem digamos que &#8220;<em>mais detalhada&#8221;<\/em> do processo. Em caso de falha ou mesmo tendo executado com sucesso.<\/p>\n<p><\/p>\n<p>Vamos l\u00e1, que na pr\u00e1tica v\u00e3o entender melhor!<\/p>\n<p>Na tela de edi\u00e7\u00e3o do Step, tem uma aba <em><strong>Advanced<\/strong><\/em>.&nbsp;<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"640\" height=\"241\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?resize=640%2C241&#038;ssl=1\" alt=\"\" class=\"wp-image-606\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?w=691&amp;ssl=1 691w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?resize=300%2C113&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?resize=520%2C196&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?resize=360%2C135&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?resize=250%2C94&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/8.png?resize=100%2C38&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Ao clicar, vai ver um campo chamado <em><strong>Output file<\/strong><\/em>, que \u00e9 o local onde vai ser guardado nosso log de execu\u00e7\u00e3o do Job. Vamos ent\u00e3o clicar no &#8220;<strong><em>pontinhos<\/em><\/strong>&#8221; e mudar para um caminho mais familiar.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"640\" height=\"257\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?resize=640%2C257&#038;ssl=1\" alt=\"\" class=\"wp-image-608\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?w=692&amp;ssl=1 692w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?resize=300%2C121&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?resize=520%2C209&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?resize=360%2C145&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?resize=250%2C100&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/10.png?resize=100%2C40&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Coloquei para ser salvo no disco F: e o nome do arquivo ser\u00e1 <strong>Log_bkpFull.txt<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"410\" height=\"209\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/11-1.png?resize=410%2C209&#038;ssl=1\" alt=\"\" class=\"wp-image-611\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/11-1.png?w=410&amp;ssl=1 410w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/11-1.png?resize=300%2C153&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/11-1.png?resize=360%2C184&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/11-1.png?resize=250%2C127&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/11-1.png?resize=100%2C51&amp;ssl=1 100w\" sizes=\"(max-width: 410px) 100vw, 410px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Feito isso, basta salvar clicando no bot\u00e3o <em><strong>OK<\/strong><\/em>. D\u00favida: Marcar ou n\u00e3o a op\u00e7\u00e3o<strong><em>&nbsp;Append output to existing file?<\/em><\/strong>&nbsp;<\/p>\n<p>Caso marque esta op\u00e7\u00e3o, a cada execu\u00e7\u00e3o do job vai ser salvo <strong>TODO O HIST\u00d3RICO<\/strong> neste arquivo txt, ou seja, se voc\u00ea acha que necessita guardar tudo, basta marcar ela. Por\u00e9m o seguinte, caso o job execute v\u00e1rias vezes durante o dia, este arquivo vai ter um hist\u00f3rico grande e por isso o bom \u00e9 lembrar de limpar alguns registro dele de vez em quando, para n\u00e3o ficar um arquivo muito grande. Mas no nosso caso, prefiro deixar desmarcado e ver apenas a mensagem da \u00faltima execu\u00e7\u00e3o, ou seja, se na pr\u00f3xima execu\u00e7\u00e3o o job rodar com sucesso, vai sobrepor o hist\u00f3rico e n\u00e3o vou ter o motivo da falha neste txt.&nbsp;<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"521\" height=\"651\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/12.png?resize=521%2C651&#038;ssl=1\" alt=\"\" class=\"wp-image-612\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/12.png?w=521&amp;ssl=1 521w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/12.png?resize=240%2C300&amp;ssl=1 240w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/12.png?resize=360%2C450&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/12.png?resize=250%2C312&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/12.png?resize=100%2C125&amp;ssl=1 100w\" sizes=\"(max-width: 521px) 100vw, 521px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos agora voltar para a execu\u00e7\u00e3o do Job e rodar ele novamente para gerar a falha e salvar no nosso arquivo txt.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"379\" height=\"161\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/13.png?resize=379%2C161&#038;ssl=1\" alt=\"\" class=\"wp-image-614\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/13.png?w=379&amp;ssl=1 379w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/13.png?resize=300%2C127&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/13.png?resize=360%2C153&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/13.png?resize=250%2C106&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/13.png?resize=100%2C42&amp;ssl=1 100w\" sizes=\"(max-width: 379px) 100vw, 379px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pronto, job falhou, agora vamos abrir o arquivo txt.<\/p>\n<p>Veja se visivelmente n\u00e3o ficou bem melhor para identificar o erro?!<\/p>\n<p><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"478\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=640%2C478&#038;ssl=1\" alt=\"\" class=\"wp-image-673\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?w=991&amp;ssl=1 991w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=768%2C573&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=700%2C523&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=520%2C388&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=360%2C269&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=250%2C187&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/14-1.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><em>The value for the parameter @Directory is not supported.<\/em> <strong>Ou seja o&nbsp;valor do par\u00e2metro @Directory n\u00e3o \u00e9 suportado<\/strong>.<\/p>\n<p>Vamos voltar no par\u00e2metro e ver onde est\u00e1 o erro, ser\u00e1 o endere\u00e7o do blob? Ser\u00e1 alguma permiss\u00e3o?&nbsp;<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"496\" height=\"174\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/15.png?resize=496%2C174&#038;ssl=1\" alt=\"\" class=\"wp-image-620\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/15.png?w=496&amp;ssl=1 496w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/15.png?resize=300%2C105&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/15.png?resize=360%2C126&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/15.png?resize=250%2C88&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/15.png?resize=100%2C35&amp;ssl=1 100w\" sizes=\"(max-width: 496px) 100vw, 496px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Voltando na documenta\u00e7\u00e3o no site, veja onde est\u00e1 o nosso erro&#8230;<\/p>\n<p>Na sess\u00e3o de exemplos diz:<\/p>\n<p><span style=\"color: #0000ff;\">E. Fazer backup de todos os bancos de dados de usu\u00e1rios para o Azure Blob Storage, usando compacta\u00e7\u00e3o<\/span><\/p>\n<p><strong><span style=\"color: #0000ff;\">EXECUTE<\/span> <span style=\"color: #000000;\">dbo. Banco de dadosBackup<\/span><\/strong><br><strong>@Databases = <span style=\"color: #ff0000;\">&#8216;USER_DATABASES&#8217;<\/span>,<\/strong><br><strong>@URL = <span style=\"color: #0000ff;\">&#8216;https:\/\/myaccount.blob.core.windows.net\/mycontainer&#8217;<\/span>,<\/strong><br><strong>@Credential =<span style=\"color: #ff0000;\"> &#8216;MyCredential&#8217;<\/span>,<\/strong><br><strong>@BackupType = <span style=\"color: #ff0000;\">&#8216;FULL&#8217;<\/span>,<\/strong><br><strong>@Compress =<span style=\"color: #ff0000;\"> &#8216;Y&#8217;<\/span>,<\/strong><br><strong>@Verify =<span style=\"color: #ff0000;\"> &#8216;Y&#8217;<\/span><\/strong><\/p>\n<p><\/p>\n<p>Portanto n\u00e3o podemos usar <strong>@Directory<\/strong>, pois nosso backup n\u00e3o ser\u00e1 local, precisamos trocar e colocar <strong>@URL<\/strong>.<\/p>\n<p>Logo ap\u00f3s a altera\u00e7\u00e3o, salvar e executar o Job novamente.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"381\" height=\"134\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/16.png?resize=381%2C134&#038;ssl=1\" alt=\"\" class=\"wp-image-623\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/16.png?w=381&amp;ssl=1 381w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/16.png?resize=300%2C106&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/16.png?resize=360%2C127&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/16.png?resize=250%2C88&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/16.png?resize=100%2C35&amp;ssl=1 100w\" sizes=\"(max-width: 381px) 100vw, 381px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Configurei o <strong>Microsoft Azure Storage Explorer<\/strong> para ver meu blob. Backup feito com sucesso!<\/p>\n<p>O backup foi feito conforme caminho do blob que colocamos no job: &#8220;backup&gt;&#8221; <strong>nome do servidor\/inst\u00e2ncia+database+FULL<\/strong> e no nome do arquivo acrescentou tamb\u00e9m a <strong>data do dia e a hora<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"173\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=640%2C173&#038;ssl=1\" alt=\"\" class=\"wp-image-629\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?w=965&amp;ssl=1 965w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=300%2C81&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=768%2C208&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=700%2C189&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=520%2C141&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=360%2C97&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=250%2C68&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/20.png?resize=100%2C27&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"189\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=640%2C189&#038;ssl=1\" alt=\"\" class=\"wp-image-630\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?w=911&amp;ssl=1 911w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=300%2C89&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=768%2C227&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=700%2C207&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=520%2C154&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=360%2C106&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=250%2C74&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/21.png?resize=100%2C30&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Visualizando direto pelo Portal do Azure:&nbsp;<\/p>\n\n\n<figure class=\"wp-block-image alignwide size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"198\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=640%2C198&#038;ssl=1\" alt=\"\" class=\"wp-image-631\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=1024%2C317&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=300%2C93&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=768%2C238&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=700%2C217&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=520%2C161&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=360%2C112&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=250%2C77&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?resize=100%2C31&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?w=1459&amp;ssl=1 1459w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/22-1.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Um <strong>poss\u00edvel erro pode acontecer<\/strong> na execu\u00e7\u00e3o deste backup e vamos simular aqui agora, veja este detalhe na Procedure:<\/p>\n<p><\/p>\n\n\n<figure class=\"wp-block-image alignwide size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"123\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=640%2C123&#038;ssl=1\" alt=\"\" class=\"wp-image-626\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?w=1154&amp;ssl=1 1154w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=300%2C57&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=1024%2C196&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=768%2C147&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=700%2C134&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=520%2C100&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=360%2C69&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=250%2C48&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/18.png?resize=100%2C19&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Ou seja, \u00e9 feito um select na credencial para verificar se j\u00e1 existe cadastrada no servidor, e caso n\u00e3o exista, retornar\u00e1 um erro.<\/strong><\/p>\n<p><\/p>\n<p>Vamos ent\u00e3o validar?<\/p>\n<p><strong><span style=\"color: #0000ff;\">select<\/span> <span style=\"color: #0000ff;\">* from<\/span> <span style=\"color: #008000;\">sys.credentials<\/span> <span style=\"color: #0000ff;\">where<\/span> <span style=\"color: #ff00ff;\">upper<\/span> (credential_identity)=<span style=\"color: #ff0000;\">&#8216;Shared Access Signature&#8217;<\/span><\/strong><\/p>\n\n\n<figure class=\"wp-block-image alignwide size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"235\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=640%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-628\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?w=1136&amp;ssl=1 1136w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=300%2C110&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=1024%2C376&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=768%2C282&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=700%2C257&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=520%2C191&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=360%2C132&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=250%2C92&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/19.png?resize=100%2C37&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>No meu caso a credencial j\u00e1 estava cadastrada. Mas e se no seu n\u00e3o estiver, como vai continuar agora? Calma, n\u00e3o vou te deixar na m\u00e3o, vamos ent\u00e3o fazer dar errado, <strong>dropando a credencial cadastrada.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"520\" height=\"149\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/24.png?resize=520%2C149&#038;ssl=1\" alt=\"\" class=\"wp-image-632\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/24.png?w=520&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/24.png?resize=300%2C86&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/24.png?resize=360%2C103&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/24.png?resize=250%2C72&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/24.png?resize=100%2C29&amp;ssl=1 100w\" sizes=\"(max-width: 520px) 100vw, 520px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos agora executar o Job novamente e ver o que acontece.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"450\" height=\"204\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/25-1.png?resize=450%2C204&#038;ssl=1\" alt=\"\" class=\"wp-image-665\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/25-1.png?w=450&amp;ssl=1 450w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/25-1.png?resize=300%2C136&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/25-1.png?resize=360%2C163&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/25-1.png?resize=250%2C113&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/25-1.png?resize=100%2C45&amp;ssl=1 100w\" sizes=\"(max-width: 450px) 100vw, 450px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Ufa, num \u00e9 que realmente deu erro!<\/p>\n<p>Verificando o erro, veja que a mensagem foi <strong>diferente da primeira no in\u00edcio do post<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"591\" height=\"426\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?resize=591%2C426&#038;ssl=1\" alt=\"\" class=\"wp-image-674\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?w=591&amp;ssl=1 591w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?resize=300%2C216&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?resize=520%2C375&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?resize=360%2C259&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?resize=250%2C180&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/26-1.png?resize=100%2C72&amp;ssl=1 100w\" sizes=\"(max-width: 591px) 100vw, 591px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Cannot open backup device &#8216;https:\/\/labsbkp.blob.core.windows.net\/backup\/DESKTOP-PKXD\/AdventureWorks2014\/FULL\/DESKT&#8230;&nbsp; The step failed.<\/strong><\/p>\n<p>Agora para dar continuidade no roteiro, vamos passar para o outro t\u00f3pico.<\/p>\n<p><\/p>\n<p><strong>2) Backups avulsos<\/strong><\/p>\n<p><strong>O jeito mais f\u00e1cil que vejo para cadastrar a credencial no SSMS \u00e9 fazendo um backup avulso<\/strong>. Ou seja, veja que legal, voc\u00ea vai aprender agora a cadastrar sua credencial e\/ou se j\u00e1 tem ela cadastrada mas n\u00e3o sabe como fazer um backup para o blob no Azure, ir\u00e1 aprender tamb\u00e9m.<\/p>\n<p>No meu outro post sobre <a href=\"https:\/\/ederlelis.com.br\/blog\/restore-database-azure-usando-ssms\/\" target=\"_blank\" rel=\"noopener\">Restore de Backups Armazenados no Azure usando Microsoft SSMS<\/a> &nbsp;tamb\u00e9m ensino a criar e salvar a credencial no servidor. Se ainda n\u00e3o viu, depois d\u00ea uma olhada!<\/p>\n<p>Primeiro vamos selecionar a Database que queremos fazer o backup para o blob.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"356\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=640%2C356&#038;ssl=1\" alt=\"\" class=\"wp-image-637\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?w=752&amp;ssl=1 752w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=300%2C167&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=700%2C389&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=520%2C289&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=360%2C200&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=250%2C139&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/27.png?resize=100%2C56&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Em seguida vamos em <em><strong>Backup Options<\/strong><\/em> para colocar a op\u00e7\u00e3o de <em><strong>Compress backup<\/strong><\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"240\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=640%2C240&#038;ssl=1\" alt=\"\" class=\"wp-image-640\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?w=897&amp;ssl=1 897w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=300%2C113&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=768%2C289&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=700%2C263&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=520%2C195&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=360%2C135&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=250%2C94&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/28.png?resize=100%2C38&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Na op\u00e7\u00e3o <em><strong>General<\/strong> <\/em>vai mostrar a Database que ser\u00e1 feito o backup e o tipo de backup, que no nosso caso ser\u00e1 o FULL. Lembrando que o destino ser\u00e1 o blob no Azure portanto <strong>URL<\/strong>. Logo em seguida basta clicar no <em><strong>Add<\/strong><\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"283\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=640%2C283&#038;ssl=1\" alt=\"\" class=\"wp-image-641\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?w=901&amp;ssl=1 901w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=300%2C133&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=768%2C339&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=700%2C309&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=520%2C230&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=360%2C159&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=250%2C110&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/29.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Se a credencial estivesse j\u00e1 salva, o campo <em><strong>Azure storage container<\/strong><\/em> estaria preenchido, da\u00ed bastaria dar <em><strong>OK<\/strong><\/em>, mas como ainda n\u00e3o temos, precisamos clicar em <em><strong>New container<\/strong><\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"532\" height=\"140\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?resize=532%2C140&#038;ssl=1\" alt=\"\" class=\"wp-image-649\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?w=532&amp;ssl=1 532w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?resize=520%2C137&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?resize=360%2C95&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?resize=250%2C66&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/30.png?resize=100%2C26&amp;ssl=1 100w\" sizes=\"(max-width: 532px) 100vw, 532px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Agora precisamos logar na conta do Azure usando o e-mail e a credencial correta, depois ir\u00e1 aparecer o <em><strong>Storage Account<\/strong><\/em> e tamb\u00e9m o <em><strong>Blob Container<\/strong><\/em>. Geramos em seguida uma credencial (<em><strong>Shared Access Signature<\/strong><\/em>) e definimos uma <strong>data de expira\u00e7\u00e3o<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"428\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?resize=640%2C428&#038;ssl=1\" alt=\"\" class=\"wp-image-642\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?w=657&amp;ssl=1 657w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?resize=520%2C347&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?resize=360%2C241&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?resize=250%2C167&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/31.png?resize=100%2C67&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Ap\u00f3s logar e preencher todos os campos, basta <strong>criar uma credencial<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"437\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?resize=640%2C437&#038;ssl=1\" alt=\"\" class=\"wp-image-643\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?w=647&amp;ssl=1 647w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?resize=300%2C205&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?resize=520%2C355&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?resize=360%2C246&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?resize=250%2C171&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/32.png?resize=100%2C68&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Credencial gerada, copie e salve, pois vai ser muito \u00fatil para fazermos backups avulsos.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"640\" height=\"223\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?resize=640%2C223&#038;ssl=1\" alt=\"\" class=\"wp-image-650\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?w=640&amp;ssl=1 640w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?resize=300%2C105&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?resize=520%2C181&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?resize=360%2C125&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?resize=250%2C87&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/33.png?resize=100%2C35&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Tudo feito e pronto para iniciar o backup. Por\u00e9m uma dica importante, ao inv\u00e9s de j\u00e1 iniciar clicando no <em>OK<\/em>, recomendo sempre quando tiver em alguma tela do SSMS e aparecer esta op\u00e7\u00e3o de &#8220;<em>Script<\/em>&#8220;, clique para gerar o script ao inv\u00e9s de clicar no <em>OK<\/em>. Pois com o script gerado na tela, \u00e9 melhor para voc\u00ea revisar o c\u00f3digo e tamb\u00e9m para validar se realmente \u00e9 o que voc\u00ea quer. E tamb\u00e9m consegue acompanhar a execu\u00e7\u00e3o (percentual) em alguns casos.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"580\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=640%2C580&#038;ssl=1\" alt=\"\" class=\"wp-image-645\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?w=730&amp;ssl=1 730w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=300%2C272&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=700%2C634&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=520%2C471&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=360%2C326&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=250%2C226&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/35.png?resize=100%2C91&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Script gerado, conferido e revisado, pronto, s\u00f3 executar e sucesso!<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"411\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=640%2C411&#038;ssl=1\" alt=\"\" class=\"wp-image-646\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?w=728&amp;ssl=1 728w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=300%2C193&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=700%2C450&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=520%2C334&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=360%2C231&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=250%2C161&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/36.png?resize=100%2C64&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Verificando no Azure, e tudo correto.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"211\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=640%2C211&#038;ssl=1\" alt=\"\" class=\"wp-image-647\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?w=1018&amp;ssl=1 1018w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=300%2C99&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=768%2C253&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=700%2C230&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=520%2C171&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=360%2C118&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=250%2C82&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/37.png?resize=100%2C33&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Que tal agora voltar no Job e tentar executar o backup novamente? Bora l\u00e1!<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"381\" height=\"212\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/38.png?resize=381%2C212&#038;ssl=1\" alt=\"\" class=\"wp-image-651\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/38.png?w=381&amp;ssl=1 381w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/38.png?resize=300%2C167&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/38.png?resize=360%2C200&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/38.png?resize=250%2C139&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/38.png?resize=100%2C56&amp;ssl=1 100w\" sizes=\"(max-width: 381px) 100vw, 381px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Conferindo novamente, backup feito com sucesso.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"182\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=640%2C182&#038;ssl=1\" alt=\"\" class=\"wp-image-652\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?w=1012&amp;ssl=1 1012w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=300%2C85&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=768%2C219&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=700%2C199&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=520%2C148&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=360%2C102&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=250%2C71&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/39.png?resize=100%2C28&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Este post j\u00e1 est\u00e1 ficando grande, rsrs, mas vou te recompensar, que tal mais um B\u00d4NUS!<\/p>\n<p>Sabia que o blob possui limita\u00e7\u00e3o de tamanho de arquivo? Pois \u00e9, sendo assim dependendo do tamanho da Database, n\u00e3o conseguir\u00e1 fazer o backup usando apenas um arquivo, como no nosso exemplo acima <strong>AdventureWorks2014_FULL.bak.<\/strong><\/p>\n<p>Sendo assim pode haver necessidade de gerar <strong>AdventureWorks2014_FULL_file1.bak , AdventureWorks2014_FULL_file2.bak , AdventureWorks2014_FULL_file3.bak<\/strong> &#8230;..<\/p>\n<p><strong>N\u00e3o vou entrar em detalhes com rela\u00e7\u00e3o a quest\u00e3o do tamanho para n\u00e3o prolongar ainda mais, por\u00e9m segue referencial da Microsoft para ajudar a entender melhor este contexto<\/strong>.<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/rest\/api\/storageservices\/understanding-block-blobs--append-blobs--and-page-blobs\" target=\"_blank\" rel=\"noopener\">Entendendo bolhas de bloco, blobs de ap\u00eandice e bolhas de p\u00e1gina &#8211; Armazenamento de Azure | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/pt-br\/archive\/blogs\/sqlcat\/backing-up-a-vldb-to-azure-blob-storage\" target=\"_blank\" rel=\"noopener\">Fazendo backup de um VLDB para o Azure Blob Storage | Microsoft Docs<\/a><\/li>\n<li>O OlaHallengren.com tamb\u00e9m comenta sobre este contexto, deixando tudo din\u00e2mico nos seus scripts. Segue print.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"278\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=640%2C278&#038;ssl=1\" alt=\"\" class=\"wp-image-653\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=1024%2C445&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=768%2C334&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=700%2C305&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=520%2C226&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=360%2C157&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=250%2C109&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?resize=100%2C44&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/extra1.png?w=1216&amp;ssl=1 1216w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Portanto vamos para a pr\u00e1tica.<\/p>\n<p>Caso voc\u00ea queira fazer o backup e dividir em v\u00e1rios arquivos \u00e9 bem simples. Basta configurar na aba <em><strong>General<\/strong> <\/em>e no bot\u00e3o <em><strong>Add<\/strong> (<\/em>onde adicionamos o backup conforme o nome que optamos), vamos ent\u00e3o acrescentar os arquivos e renomear conforme necess\u00e1rio para obter um bom entendimento. <strong>Basta ir adicionando um por um<\/strong>. Quando terminar, clique no <em><strong>Script<\/strong> <\/em>para visualizar o c\u00f3digo gerado.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"281\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=640%2C281&#038;ssl=1\" alt=\"\" class=\"wp-image-654\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?w=896&amp;ssl=1 896w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=300%2C132&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=768%2C338&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=700%2C308&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=520%2C229&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=360%2C158&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=250%2C110&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/40.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Nosso script est\u00e1 todo OK, veja que o backup vai ser dividido em 3 arquivos. <em><strong>F5<\/strong><\/em> para executar e pronto.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"313\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=640%2C313&#038;ssl=1\" alt=\"\" class=\"wp-image-655\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?w=1002&amp;ssl=1 1002w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=300%2C147&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=768%2C376&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=700%2C342&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=520%2C254&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=360%2C176&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=250%2C122&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/41.png?resize=100%2C49&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos agora conferir como ficou. Veja o comparativo do tamanho dos arquivos.&nbsp;<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"477\" height=\"184\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/43.png?resize=477%2C184&#038;ssl=1\" alt=\"\" class=\"wp-image-656\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/43.png?w=477&amp;ssl=1 477w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/43.png?resize=300%2C116&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/43.png?resize=360%2C139&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/43.png?resize=250%2C96&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/43.png?resize=100%2C39&amp;ssl=1 100w\" sizes=\"(max-width: 477px) 100vw, 477px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"207\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=640%2C207&#038;ssl=1\" alt=\"\" class=\"wp-image-657\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?w=966&amp;ssl=1 966w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=300%2C97&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=768%2C248&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=700%2C226&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=520%2C168&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=360%2C116&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=250%2C81&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/42.png?resize=100%2C32&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Para finalizar nossa automatiza\u00e7\u00e3o do backup, faltou apenas criar schedule com o hor\u00e1rio. Basta nas propriedades do Job clicar em <em><strong>Schedules<\/strong><\/em> e depois em <em><strong>New<\/strong> <\/em>e ent\u00e3o colocar qual ser\u00e1 a frequ\u00eancia de execu\u00e7\u00e3o e o hor\u00e1rio. Clicar em <em><strong>OK<\/strong><\/em> para salvar e aguardar a execu\u00e7\u00e3o.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"715\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?resize=640%2C715&#038;ssl=1\" alt=\"\" class=\"wp-image-658\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?w=693&amp;ssl=1 693w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?resize=269%2C300&amp;ssl=1 269w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?resize=520%2C581&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?resize=360%2C402&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?resize=250%2C279&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/44.png?resize=100%2C112&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"144\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=640%2C144&#038;ssl=1\" alt=\"\" class=\"wp-image-659\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?w=712&amp;ssl=1 712w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=300%2C67&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=700%2C157&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=520%2C117&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=360%2C81&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=250%2C56&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/45.png?resize=100%2C22&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos validar?<\/p>\n<p><strong>Pronto, segue hist\u00f3rico de backups realizados. Temos o backup executado manualmente e depois a execu\u00e7\u00e3o do backup feito via Job \u00e0s 22h, conforme podemos ver o usu\u00e1rio do Agent.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"59\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=640%2C59&#038;ssl=1\" alt=\"\" class=\"wp-image-660\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=1024%2C95&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=300%2C28&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=768%2C71&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=700%2C65&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=520%2C48&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=360%2C33&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=250%2C23&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?resize=100%2C9&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?w=1335&amp;ssl=1 1335w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/46.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>\u00c9 isso pessoal, obrigado e espero que tenha contribu\u00eddo alguma coisa para o seu aprendizado.<\/p>\n<p>Quaisquer d\u00favidas, sugest\u00f5es, podem mandar mensagens, escrever nos coment\u00e1rios&#8230;<\/p>\n<p><strong>At\u00e9 breve! #gogogo<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Para aqueles que querem criar um Job de Backup e automatizar o trabalho pensando principalmente em seguran\u00e7a, afinal, se um dia algo acontecer com meu banco de dados, ser\u00e1 que est\u00e1 preparado? Quanto &#8220;tempo de dados&#8221; posso perder?<\/p>\n<p>1) Automatiza\u00e7\u00e3o de backup<br \/>\nPara criarmos um job de backup vou usar os scripts do OlaHallengren, devido ter uma licen\u00e7a de c\u00f3digo aberto popular e amplamente utilizada. Podendo ser usado em Microsoft SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 e SQL Server 2019.<br \/>\n2) Backups avulsos<br \/>\nO jeito mais f\u00e1cil que vejo para cadastrar a credencial no SSMS \u00e9 fazendo um backup avulso.<\/p>\n","protected":false},"author":1,"featured_media":677,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[1,25],"tags":[14,15,17,22,21,23,20,16,18],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/topo_bkp_aut3.png?fit=407%2C316&ssl=1","jetpack-related-posts":[{"id":1406,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/","url_meta":{"origin":538,"position":0},"title":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE1)","date":"janeiro 20, 2025","format":false,"excerpt":"\u2026 vou seguir com meus objetivos e iniciar uma \u201cs\u00e9rie\u201d de post cujo assunto ser\u00e1 \u201cMigra\u00e7\u00e3o On-Premise para Azure SQL\u201d Portanto darei o nome deste de hoje como \u2026PARTE1. Para migrar um database do On-Premise para o Azure SQL temos v\u00e1rias op\u00e7\u00f5es. Cada op\u00e7\u00e3o tem suas vantagens e desvantagens espec\u00edficas.\u2026","rel":"","context":"Com 1 coment\u00e1rio","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/banner.png?fit=616%2C520&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1484,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte2\/","url_meta":{"origin":538,"position":1},"title":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE2)","date":"fevereiro 8, 2025","format":false,"excerpt":"...Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise. Se voc\u00ea ainda n\u00e3o leu o primeiro post da s\u00e9rie, d\u00ea uma olhada, ficou bem completo. Usei o m\u00e9todo \u201cDeploy Database to Microsoft Azure SQL Database\u201d, detalhando cada passo. 1) Deploy Database to Microsoft Azure SQL Database (link\u2026","rel":"","context":"Com 1 coment\u00e1rio","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/banner.png?fit=474%2C422&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1580,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-de-banco-de-dados-on-premise-para-azure-sql-parte3\/","url_meta":{"origin":538,"position":2},"title":"Migra\u00e7\u00e3o de Banco de Dados On-Premise para Azure SQL (PARTE3)","date":"fevereiro 26, 2025","format":false,"excerpt":"\u2026Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise. Se voc\u00ea ainda n\u00e3o leu os posts anteriores, d\u00ea uma olhada. 1) Deploy Database to Microsoft Azure SQL Database. 2) Backup bacpac com import Agora, na Parte 3, vamos explorar a migra\u00e7\u00e3o usando o DMA. 3. DMA (Data\u2026","rel":"","context":"Post similar","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/dma.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":339,"url":"https:\/\/ederlelis.com.br\/blog\/restore-database-azure-usando-ssms\/","url_meta":{"origin":538,"position":3},"title":"Restore de Backups Armazenados no Azure usando Microsoft SSMS","date":"abril 10, 2022","format":false,"excerpt":"Neste primeiro Post do meu blog abordarei um assunto que a cada dia que passa, quanto mais aprendo, mais quero aprender, SQL x Azure. Vamos fazer um Restore de Backups armazenados no Blob do Azure usando o Microsoft SQL Server Management Studio (SSMS).","rel":"","context":"Em \"Azure\"","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/03\/00.png?fit=447%2C222&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1324,"url":"https:\/\/ederlelis.com.br\/blog\/retrospectiva-ano-2024\/","url_meta":{"origin":538,"position":4},"title":"Retrospectiva Ano 2024!","date":"janeiro 4, 2025","format":false,"excerpt":"Retrospectiva Ano 2024! Ol\u00e1, espero que voc\u00ea esteja bem! \ud83d\ude09 Vamos juntos para a Retrospectiva do Ano 2024. Como refer\u00eancia, vou usar a retrospectiva do ano passado para validar algumas metas que foram tra\u00e7adas e comparar se consegui alcan\u00e7\u00e1-las. Al\u00e9m do crescimento t\u00e9cnico, este ano provou o poder do aprendizado\u2026","rel":"","context":"Em &quot;Retrospectiva&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/retro2024.jpeg?fit=1080%2C881&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":424,"url":"https:\/\/ederlelis.com.br\/blog\/criptografia-dados-transparente-tde-criptografar-database-mssql\/","url_meta":{"origin":538,"position":5},"title":"Criptografia  Dados Transparente &#8211; TDE: Como Criptografar sua Database MSSQL?","date":"abril 9, 2022","format":false,"excerpt":"Neste post vou falar de uma demanda que est\u00e1 aumentando muito atualmente, devido a LGPD. Portanto, com base nesse processo de gest\u00e3o e governan\u00e7a de dados, um grande aliado \u201cagregado\u201d ao SQL Server \u00e9 o TDE (Transparent Data Encryption). A criptografia de dados transparente criptografa os arquivos de dados (mdf)\u2026","rel":"","context":"Em &quot;MSSQL&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/04\/cadeado.jpeg?fit=595%2C501&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/538"}],"collection":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/comments?post=538"}],"version-history":[{"count":66,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/538\/revisions"}],"predecessor-version":[{"id":711,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/538\/revisions\/711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media\/677"}],"wp:attachment":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media?parent=538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/categories?post=538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/tags?post=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}