{"id":1053,"date":"2012-12-01T03:46:43","date_gmt":"2012-12-01T08:46:43","guid":{"rendered":"http:\/\/swildow.darktech.org\/wp\/?page_id=1053"},"modified":"2014-12-24T04:00:39","modified_gmt":"2014-12-24T09:00:39","slug":"scripts","status":"publish","type":"page","link":"http:\/\/www.wildow.com\/blog\/?page_id=1053","title":{"rendered":"scripts"},"content":{"rendered":"<p>Windows backup script<\/p>\n<p>&nbsp;<\/p>\n<p>rem<br \/>\necho %computername% %date% %time% &gt;&gt; c:\\bat\\synclog.txt<br \/>\nfor \/f &#8220;Tokens=1-4 Delims=\/ &#8221; %%i in (&#8216;date \/t&#8217;) do set dt=%%i-%%j-%%k-%%l<br \/>\nfor \/f &#8220;Tokens=1&#8221; %%i in (&#8216;time \/t&#8217;) do set tm=-%%i<br \/>\nset tm=%tm::=-%<br \/>\nset dtt=%dt%%tm%<\/p>\n<p>wbadmin start backup -include:c:\u00a0 -backupTarget:e: -systemstate -allcritical -quiet &gt;&gt;log.txt<br \/>\nrem wbadmin start systemstatebackup -backuptarget:e: -quiet &gt;&gt;log.txt<\/p>\n<p>echo %computername% %date% %time% &gt; c:\\bat\\backlogemail.txt<br \/>\ndir c:\\ &gt;&gt; c:\\bat\\backlogemail.txt<br \/>\ntype log.txt &gt;&gt; c:\\bat\\backlogemail.txt<br \/>\n:::::::::::::: Lets set some variables ::::::::::::::<br \/>\nset eMail=steve@tech.net<br \/>\nset efrom=administrator@inc.org<br \/>\nset subj=-s &#8220;dc4 backup&#8221;<br \/>\nset server=-server smtp-server.woh.rr.com<br \/>\nset attachf=-attacht backlogemail.txt<br \/>\nset debug=-debug -log blat.log -timestamp<br \/>\n::::::::::::::::: Now we run Blat!\u00a0 :::::::::::::::::<br \/>\nblat %0 -to %eMail% -f %efrom% %subj% %attachf% %server% %debug%<\/p>\n<p><strong>delete files from a directory and keep last 15 days<\/strong><\/p>\n<p>forfiles \/P y:\\backup2\\sqlbackup \/D -15 \/C &#8220;cmd \/c del @path&#8221;\u00a0 &gt;&gt; c:\\bat\\deletelog.txt<\/p>\n<p><strong>copy and keep last 7 days<\/strong><\/p>\n<p>robocopy &#8220;C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Backup&#8221; D:\\backup \/MOV \/MINAGE:7<\/p>\n<p>rem delete extra log files<\/p>\n<p>forfiles \/P c:\\bat\\logs \/D -30 \/C &#8220;cmd \/c del @path&#8221;\u00a0 &gt;&gt; c:\\bat\\deletelog.txt<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Windows backup script &nbsp; rem echo %computername% %date% %time% &gt;&gt; c:\\bat\\synclog.txt for \/f &#8220;Tokens=1-4 Delims=\/ &#8221; %%i in (&#8216;date \/t&#8217;) do set dt=%%i-%%j-%%k-%%l for \/f &#8220;Tokens=1&#8221; %%i in (&#8216;time \/t&#8217;) do set tm=-%%i set tm=%tm::=-% set dtt=%dt%%tm% wbadmin start backup &#8230; <a class=\"more-link\" href=\"http:\/\/www.wildow.com\/blog\/?page_id=1053\">Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":713,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/pages\/1053"}],"collection":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1053"}],"version-history":[{"count":4,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/pages\/1053\/revisions"}],"predecessor-version":[{"id":1442,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/pages\/1053\/revisions\/1442"}],"up":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/pages\/713"}],"wp:attachment":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}