{"id":7653,"date":"2017-04-03T07:30:14","date_gmt":"2017-04-03T10:30:14","guid":{"rendered":"http:\/\/www.fabriciolima.net\/?p=7653"},"modified":"2017-04-03T07:30:14","modified_gmt":"2017-04-03T10:30:14","slug":"video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/","title":{"rendered":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?"},"content":{"rendered":"<p>Fala Pessoal,<\/p>\n<p>O objetivo do v\u00eddeo de hoje \u00e9\u00a0mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7656 aligncenter\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1.png\" alt=\"\" width=\"562\" height=\"163\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1.png 917w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-300x87.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-768x224.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-700x204.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-410x119.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-100x29.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-275x80.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1-20x6.png 20w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/p>\n<p>Essa \u00e9 uma das d\u00favidas mais comuns\u00a0que vejo nos f\u00f3runs, palestras e treinamentos. Principalmente para quem est\u00e1 come\u00e7ando no mundo SQL Server.<\/p>\n<p>Segue o v\u00eddeo com a explica\u00e7\u00e3o:<\/p>\n<p><iframe loading=\"lazy\" width=\"1170\" height=\"658\" src=\"https:\/\/www.youtube.com\/embed\/cXQvhTKOE8o?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p>Segue o script utilizado na Demo para download: <a href=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/ScriptPostRecoveryFULLeSIMPLE.txt\" target=\"_blank\">Script Demo<\/a><\/p>\n<p>Abaixo o post que citei no v\u00eddeo para criar um alerta e monitorar o Transaction Log:<\/p>\n<p><a href=\"https:\/\/www.fabriciolima.net\/blog\/2017\/01\/12\/alerta-monitorando-o-tamanho-do-transaction-log-no-sql-server\/\" target=\"_blank\">https:\/\/www.fabriciolima.net\/blog\/2017\/01\/12\/alerta-monitorando-o-tamanho-do-transaction-log-no-sql-server\/<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-7019 aligncenter\" src=\"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL.png\" alt=\"\" width=\"583\" height=\"248\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL.png 1514w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-300x128.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-1024x436.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-768x327.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-700x298.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-410x174.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-100x43.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-275x117.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL-20x9.png 20w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><b>Gostou dessa dica?<\/b><\/p>\n<p>Curta, comente, compartilhe com os coleguinhas\u2026<\/p>\n<p>Assine meu canal no <a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.youtube.com\/channel\/UCeBRAO_LLrUdSrOXIywjzRA\" target=\"_blank\" rel=\"nofollow external noopener noreferrer\" data-wpel-link=\"external\">Youtube<\/a> e curta minha <a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.facebook.com\/FabricioLimaSolucoesemBancodeDados\/\" target=\"_blank\" rel=\"external noopener noreferrer nofollow\" data-wpel-link=\"external\">P\u00e1gina no Facebook<\/a> para receber Dicas de Leituras e Eventos sobre SQL Server.<\/p>\n<p>At\u00e9 a pr\u00f3xima.<\/p>\n<p>Abra\u00e7os,<\/p>\n<p>Fabr\u00edcio Lima<\/p>\n<p>Microsoft Data Platform MVP<\/p>\n<p>Consultor e Instrutor SQL Server<\/p>\n<p>Trabalha com SQL Server desde 2006<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9\u00a0mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns\u00a0que vejo nos f\u00f3runs, palestras e treinamentos. Principalmente para quem est\u00e1 come\u00e7ando no mundo SQL Server. Segue o v\u00eddeo com a explica\u00e7\u00e3o: Segue o script utilizado na Demo para download: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[3,33,1187,280],"tags":[1496,118,1497,1493,1408,1494,1495,1491,1490,1492,33,116],"class_list":["post-7653","post","type-post","status-publish","format-standard","hentry","category-administracao-de-bd","category-sql-server","category-treinamento-sql-server-2","category-virtual-pass-br","tag-arquivo-log-sql-server","tag-backup-log","tag-dbcc-sqlperflogspace","tag-diferenca-recovery-model","tag-log-cheio-sql-server","tag-log-full-sql-server","tag-problema-backup-log-sql-server","tag-recovery-full","tag-recovery-model","tag-recovery-simple","tag-sql-server","tag-transaction-log"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/7653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/comments?post=7653"}],"version-history":[{"count":0,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/7653\/revisions"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=7653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=7653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=7653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}