2

I have Microsoft SQL Server 2014 on an Azure VM (Windows Server 2012 R2) with one database. Is it possible to configure an automatic backup to my Google Drive folder? Maybe a special tool or somethings else?

  • What's an automatic backup? Is it a backup created automatically by job/script at scheduled times or one that's done manually and uploaded automatically onto the Google drive? For achieving all of these you'll need some manual scripting. – Marian Apr 19 '16 at 9:27
  • this post got famous: dbareactions.com/post/143016494130/… :D – Federico Apr 19 '16 at 17:56
  • 1
    I'm using SQLBackupAndFTP. This tool creates backups according to my schedule and sends them to my Google Drive. You can find more info here: sqlbackupandftp.com/blog/… – user89558 Aug 31 '16 at 8:55
5
  1. Download the Google Drive desktop application.
  2. When backing up SQL Server, set the destination to the "My Drive" folder created by Google Drive (something like C:\Users\<user>\Google Drive by default)
  3. Once a backup is placed in that folder, it will automatically start to sync to Google Drive.

Also worth nothing, as per Shawn Melton's comment:

You can adjust the folder location for the drive application, so it does not have to reside in a user folder. Any Administrator can actually remove a user profile and you just lost all your backups (locally at least).

  • But this solution has a huge flaw: you will not get informed if the upload is unsuccessful. Wouldn't it be better to have a batch script with a command line tool, like gdrive ? – Twinkles Apr 20 '16 at 11:29
  • @Twinkles There certainly could be a more complex and efficient approach to this - but based on the fact that GDrive is being used for backups, I chose to keep the scope small on the assumption that a complicated solution is not what the question/user required. – LowlyDBA Apr 20 '16 at 14:49
  • I get that. However, if a solution can lead to backups failing silently, the user better be aware of the risk. – Twinkles Apr 20 '16 at 17:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.