{"id":784,"date":"2020-05-13T18:14:43","date_gmt":"2020-05-13T21:14:43","guid":{"rendered":"http:\/\/jonescarvalho.com\/Blog\/?p=784"},"modified":"2020-05-13T18:47:52","modified_gmt":"2020-05-13T21:47:52","slug":"job-para-backup-diario-com-comando-para-apagar-em-x-dias","status":"publish","type":"post","link":"https:\/\/jonescarvalho.com\/Blog\/?p=784","title":{"rendered":"Job para backup di\u00e1rio com comando para apagar em x dias"},"content":{"rendered":"<p>Primeiro defina um local com o arquivo com seu script de backup ( coloquei o meu em c:\\job\\), o conte\u00fado pode ser assim como a seguir, e aproveitando, coloque um script para limpeza de logs:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SET QUOTED_IDENTIFIER ON;\n\nDECLARE @MyFileName varchar(1000)\n\nSELECT @MyFileName = (SELECT 'C:\\BACKUP\\SuaBaseBackup_' + convert(varchar(500),GetDate(),112) + '.bak')\nBACKUP DATABASE [SuaBaseBackup] TO DISK=@MyFileName\n\nGO\n\nuse [SuaBaseBackup]\ngo\nalter database [SuaBaseBackup] set Recovery simple\ndbcc SHRINKFILE([SuaBaseBackup_log],5)\nAlter database [SuaBaseBackup] set Recovery Full\n\ngo<br \/><br \/><\/pre>\n<p>Aconselho adicionar o script a seguir em um arquivo bat e executar a cada x tempo de sua preferencia<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"powershell\">sqlcmd -S localhost -U sa -P Sc@nTh0r* -i \"C:\\job\\sqljob.sql\" timeout 10 FORFILES \/p C:\\BACKUP\\ \/d -10 \/m * \/c \"cmd \/c del @file\"<\/pre>\n<p>\u00a0<\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Primeiro defina um local com o arquivo com seu script de backup ( [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[6,62,82,30],"class_list":["post-784","post","type-post","status-publish","format-standard","hentry","category-dicas","tag-banco-de-dados","tag-bat","tag-script","tag-sql"],"_links":{"self":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/784"}],"collection":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=784"}],"version-history":[{"count":11,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/784\/revisions"}],"predecessor-version":[{"id":828,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/784\/revisions\/828"}],"wp:attachment":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}