{"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":{"footnotes":"","jetpack_post_was_ever_published":false},"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"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Fabr\u00edcio Lima\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta property=\"og:description\" content=\"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2017-04-03T10:30:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2017-04-03T10:30:14+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#blogposting\",\"name\":\"V\\u00eddeo: Qual a diferen\\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"headline\":\"V\\u00eddeo: Qual a diferen\\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?\",\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.fabriciolima.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/RecoverySimpleFull-1.png\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#articleImage\"},\"datePublished\":\"2017-04-03T07:30:14-03:00\",\"dateModified\":\"2017-04-03T07:30:14-03:00\",\"inLanguage\":\"pt-BR\",\"commentCount\":4,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#webpage\"},\"articleSection\":\"Administra\\u00e7\\u00e3o de Banco de Dados, SQL Server, Treinamento SQL Server, Virtual PASS BR, arquivo log sql server, BACKUP LOG, dbcc sqlperf(logspace), diferen\\u00e7a recovery model, log cheio sql server, log full sql server, problema backup log sql server, recovery full, recovery model, recovery simple, SQL Server, Transaction Log\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"position\":2,\"name\":\"SQL Server\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"position\":3,\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#listItem\",\"name\":\"V\\u00eddeo: Qual a diferen\\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#listItem\",\"position\":4,\"name\":\"V\\u00eddeo: Qual a diferen\\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/administracao-de-bd\\\/#listItem\",\"name\":\"Administra\\u00e7\\u00e3o de Banco de Dados\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/\",\"name\":\"Fabr\\u00edcio Lima\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Fabr\\u00edcio Lima\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#webpage\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/\",\"name\":\"V\\u00eddeo: Qual a diferen\\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Fala Pessoal, O objetivo do v\\u00eddeo de hoje \\u00e9 mostrar a diferen\\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \\u00e9 uma das d\\u00favidas mais comuns que 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: https:\\\/\\\/www.youtube.com\\\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2017\\\/04\\\/03\\\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"datePublished\":\"2017-04-03T07:30:14-03:00\",\"dateModified\":\"2017-04-03T07:30:14-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para","canonical_url":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#blogposting","name":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA","headline":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?","author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/04\/RecoverySimpleFull-1.png","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#articleImage"},"datePublished":"2017-04-03T07:30:14-03:00","dateModified":"2017-04-03T07:30:14-03:00","inLanguage":"pt-BR","commentCount":4,"mainEntityOfPage":{"@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#webpage"},"isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#webpage"},"articleSection":"Administra\u00e7\u00e3o de Banco de Dados, SQL Server, Treinamento SQL Server, Virtual PASS BR, arquivo log sql server, BACKUP LOG, dbcc sqlperf(logspace), diferen\u00e7a recovery model, log cheio sql server, log full sql server, problema backup log sql server, recovery full, recovery model, recovery simple, SQL Server, Transaction Log"},{"@type":"BreadcrumbList","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/fabriciolima.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","position":2,"name":"SQL Server","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","name":"Administra\u00e7\u00e3o de Banco de Dados"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","position":3,"name":"Administra\u00e7\u00e3o de Banco de Dados","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#listItem","name":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#listItem","position":4,"name":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?","previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/#listItem","name":"Administra\u00e7\u00e3o de Banco de Dados"}}]},{"@type":"Organization","@id":"https:\/\/fabriciolima.net\/blog\/#organization","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","url":"https:\/\/fabriciolima.net\/blog\/"},{"@type":"Person","@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author","url":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/","name":"Fabr\u00edcio Lima","image":{"@type":"ImageObject","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g","width":96,"height":96,"caption":"Fabr\u00edcio Lima"}},{"@type":"WebPage","@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#webpage","url":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/","name":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/#breadcrumblist"},"author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"creator":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"datePublished":"2017-04-03T07:30:14-03:00","dateModified":"2017-04-03T07:30:14-03:00"},{"@type":"WebSite","@id":"https:\/\/fabriciolima.net\/blog\/#website","url":"https:\/\/fabriciolima.net\/blog\/","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","og:type":"article","og:title":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA","og:description":"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para","og:url":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/","article:published_time":"2017-04-03T10:30:14+00:00","article:modified_time":"2017-04-03T10:30:14+00:00","twitter:card":"summary_large_image","twitter:title":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL? - Fabricio Lima | Neg\u00f3cios, Dados e IA","twitter:description":"Fala Pessoal, O objetivo do v\u00eddeo de hoje \u00e9 mostrar a diferen\u00e7a entre o recovery SIMPLE e o recovery FULL. Essa \u00e9 uma das d\u00favidas mais comuns que 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: https:\/\/www.youtube.com\/watch?v=cXQvhTKOE8o Segue o script utilizado na Demo para"},"aioseo_meta_data":{"post_id":"7653","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-04 23:44:42","updated":"2026-07-04 23:44:42"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/\" title=\"SQL Server\">SQL Server<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/\" title=\"Administra\u00e7\u00e3o de Banco de Dados\">Administra\u00e7\u00e3o de Banco de Dados<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tV\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/fabriciolima.net\/blog"},{"label":"SQL Server","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/"},{"label":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},{"label":"V\u00eddeo: Qual a diferen\u00e7a entre o Recovery Model SIMPLE e o Recovery Model FULL?","link":"https:\/\/fabriciolima.net\/blog\/2017\/04\/03\/video-qual-a-diferenca-entre-o-recovery-model-simple-e-o-recovery-model-full\/"}],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":6981,"url":"https:\/\/fabriciolima.net\/blog\/2017\/01\/12\/alerta-monitorando-o-tamanho-do-transaction-log-no-sql-server\/","url_meta":{"origin":7653,"position":0},"title":"Alerta: Monitorando o tamanho do Transaction Log no SQL Server","author":"Fabr\u00edcio Lima","date":"12 de janeiro de 2017","format":false,"excerpt":"Ol\u00e1 Pessoal, Hoje vou compartilhar com voc\u00eas um script pronto para voc\u00ea monitorar o Transaction Log do seu SQL Server. Cen\u00e1rio real do Dia a Dia: J\u00e1 perdi as contas de quantos clientes j\u00e1 me procuraram com uma base de dados parada e com uma mensagem de Transaction Log FULL.\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"alertalogfull","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2017\/01\/AlertaLogFULL.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1352,"url":"https:\/\/fabriciolima.net\/blog\/2012\/03\/21\/simulado-para-a-prova-70-432-%e2%80%93-parte-9\/","url_meta":{"origin":7653,"position":1},"title":"Simulado para a prova 70-432 \u2013 Parte 9","author":"Fabr\u00edcio Lima","date":"21 de mar\u00e7o de 2012","format":false,"excerpt":"Fala Pessoal, Segue mais um simulado com 5 quest\u00f5es para a Prova 70-432 - Microsoft SQL Server 2008 - Implementation and Maintenance. \u00a0 1) Voc\u00ea decidiu implementar a solu\u00e7\u00e3o de Log Shipping em uma de suas databases. Para garantir que essa solu\u00e7\u00e3o n\u00e3o vai parar, voc\u00ea n\u00e3o pode permitir que\u2026","rel":"","context":"Em &quot;Certifica\u00e7\u00e3o SQL Server&quot;","block_context":{"text":"Certifica\u00e7\u00e3o SQL Server","link":"https:\/\/fabriciolima.net\/blog\/category\/certificacao-2\/certificacao\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9187,"url":"https:\/\/fabriciolima.net\/blog\/2018\/07\/17\/azure-sql-database-quanto-posso-usar-de-transaction-log-e-ilimitado\/","url_meta":{"origin":7653,"position":2},"title":"Azure SQL Database &#8211; Quanto posso usar de Transaction Log? \u00c9 ilimitado?","author":"Fabr\u00edcio Lima","date":"17 de julho de 2018","format":false,"excerpt":"Fala Pessoal, Continuando os posts sobre Azure SQL Database, dessa vez vamos falar sobre um erro de Log Full que consegui gerar em uma base no Azure. O Transaction Log de uma base no azure funciona da mesma forma que em uma inst\u00e2ncia On-Premise. Como no azure n\u00e3o conseguimos utilizar\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/07\/AzureSQLDatabaseFotoE03.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/07\/AzureSQLDatabaseFotoE03.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/07\/AzureSQLDatabaseFotoE03.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":3129,"url":"https:\/\/fabriciolima.net\/blog\/2014\/11\/03\/treinamento-sql-server-tarefas-do-dia-a-dia-de-um-dba\/","url_meta":{"origin":7653,"position":3},"title":"Treinamento SQL Server: Tarefas do dia a dia de um DBA","author":"Fabr\u00edcio Lima","date":"3 de novembro de 2014","format":false,"excerpt":"\u00a0 Ol\u00e1 Pessoal, Um amigo quer entrar para a \u00e1rea de administra\u00e7\u00e3o de banco de dados e me solicitou um treinamento que abordasse as atividades de um DBA no seu dia a dia de trabalho. Diante disso, resolvi preparar um treinamento para ele, mas abrirei o treinamento para mais 4\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2014\/11\/Treinamento.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":668,"url":"https:\/\/fabriciolima.net\/blog\/2011\/05\/04\/como-fica-meu-restore-ao-executar-backups-full-e-do-log-ao-mesmo-tempo\/","url_meta":{"origin":7653,"position":4},"title":"Como fica meu Restore ao executar Backups FULL e do LOG ao mesmo tempo?","author":"Fabr\u00edcio Lima","date":"4 de maio de 2011","format":false,"excerpt":"Fala Pessoal, Aproveitando o \u00f3timo post do Silas Mendes (Backup FULL reinicia sequ\u00eancia do LOG. Mito?), resolvi tirar uma d\u00favida antiga que tinha sobre backups Full e do Log, mas ainda n\u00e3o tinha parado para realizar os testes. A minha d\u00favida \u00e9 a seguinte: O que acontece se eu executar\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2011\/04\/BackupFULL_1-300x37.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":194,"url":"https:\/\/fabriciolima.net\/blog\/2010\/12\/19\/casos-do-dia-a-dia-voce-sabia-que-um-arquivo-de-log-do-sql-server-se-fragmenta\/","url_meta":{"origin":7653,"position":5},"title":"Casos do Dia a Dia &#8211; Voc\u00ea sabia que um arquivo de Log do SQL Server se fragmenta?","author":"Fabr\u00edcio Lima","date":"19 de dezembro de 2010","format":false,"excerpt":"Fala Pessoal, Vou ser sincero com voc\u00eas, at\u00e9 pouco tempo eu n\u00e3o tinha a menor id\u00e9ia que um arquivo de log do SQL Server se fragmentava. Nunca tinha lido\u00a0sobre o assunto. Entretanto, para isso que servem os mais 100 Blogs de SQL Server cadastrados no meu google reader e os\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2010\/12\/dbcc-loginfo.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"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}]}}