{"id":2132,"date":"2019-10-07T22:54:47","date_gmt":"2019-10-08T04:54:47","guid":{"rendered":"https:\/\/bt.beerprojects.com\/wordpress\/?p=2132"},"modified":"2019-10-07T22:55:16","modified_gmt":"2019-10-08T04:55:16","slug":"google-backup-sync-problems","status":"publish","type":"post","link":"https:\/\/bt.beerprojects.com\/wordpress\/?p=2132","title":{"rendered":"Google Backup Sync Problems"},"content":{"rendered":"\n<p>I discovered that many excel save problems I&#8217;ve been having are a result of the &#8220;new&#8221; Google Backup Sync program.  In Windows MS Office when a file is open it creates a ~filename temp\/lock file.  With BackupSync running, it would backup\/copy this file and somehow it wouldn&#8217;t release the file.  Then when saving in Excel the save would fail.<\/p>\n\n\n\n<p>So I decided to only turn Backupsync at night and then turn off 2 hours later.  That should be enough time to copy everything from the previous day and if not it should eventually catch up.<\/p>\n\n\n\n<p>To turn it on I setup a TaskManager task to simple trigger at 3am and start the program.<\/p>\n\n\n\n<p>To turn it off is a bit more complicated.  In the end I created a .bat file based on <a rel=\"noreferrer noopener\" aria-label=\"this post (opens in a new tab)\" href=\"https:\/\/stackoverflow.com\/questions\/33822\/any-way-to-write-a-windows-bat-file-to-kill-processes\" target=\"_blank\">this post<\/a>.  Which resulted in the code below.  From there I have another TaskManager task to run the .bat file at 5am<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>tasklist \/fi &#8220;imagename eq googledrivesync.exe&#8221; | find &#8220;:&#8221; > nul<\/p><p>if errorlevel 1 taskkill \/f \/im &#8220;googledrivesync.exe&#8221;<\/p><\/blockquote>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I discovered that many excel save problems I&#8217;ve been having are a result of the &#8220;new&#8221; Google Backup Sync program. In Windows MS Office when a file is open it creates a ~filename temp\/lock file. With BackupSync running, it would backup\/copy this file and somehow it wouldn&#8217;t release the file. Then when saving in Excel [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-2132","post","type-post","status-publish","format-standard","hentry","category-tech-talk"],"_links":{"self":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2132"}],"version-history":[{"count":1,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2132\/revisions"}],"predecessor-version":[{"id":2133,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2132\/revisions\/2133"}],"wp:attachment":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}