Not Just Another Weblog

For anyone backing up their Google Drive files, there's good news and bad news.  Legitimate file types such as .doc or .docx (Microsoft Word) files should be fine.  However, if you're backing up those .gdoc filetypes, don't hold your breath.  If you have deleted a .gdoc file within Google Drive and emptied the Google Drive Trash, that's it .  Nothing but a warrantless wiretap from the FBI will get it back, and even then, notsomuch for you and I. More from Google Drive 'help,' such as it is.  One more shortcoming of Google Drive: the file extensions are misleading.  This is crap ! " Anything that has been permanently deleted from Google Drive by the owner, or if the owner's account was deleted, can't be recovered . " If anyone has any suggestions for backing up the .GDOC files, the actual files,  such that they can be restored later, please post in the comments.

I am losing count, having just recovered from the third or fourth Google Drive failure in a month across two PC's.  This latest followed an unexpected shutdown, (a BSOD of an as yet unknown nature), which left a SQLite database in an unusable state: Google Drive needs to be closed. ...unknown error occurred and Google Drive needs to be closed. Error: database disk image is malformed If you continue to see this error, try to disassociate your account [*sigh*] One Google (overlord) Groups thread from 2012 suggests using other services. e.g. EverNote, DropBox, and even (gasp!) Microsoft SkyDrive-- Really ? (Lord) Google searches revealed that virtually anyone with some SQL skills might be able to recover from this.  I am not a DBA.  Having some very skilled DBA's at work has resulted in my leaving that skillset wanting.... Folks working in I.T. and/or with related skills can generally deal with and recover from interruptions/failures like these one way or anothe...

Huge, huge props to the person that posted this information .  What a lifesaver, since our Google Overlords have been merciful and gracious absolutely useless in responding to this problem.  What a bunch of drones!  Anyhow, here's the fix that worked for me (thanks to Guru ). Start Google Drive Hold the SHIFT key down and click the Google Drive systray icon, which will show the 'Enable diagnostic mode' special menu. Click ' Enable diagnostic mode' menu. Wait until Google Drive crashes and shows the "primary key must be unique" error message. Let the application shutdown. Go to "c:\Users\%username%\AppData\Local\Google\Drive" folder and open " sync_log.log ".  (If it opens slowly with Windows Notepad, I recommend using Notepad++ instead) Search /find (CTRL + F) for this text: " Detected conflict while trying to download file to". After 'to' is the file name associated with the conflict. Rename it. Do this for...