{"id":220,"date":"2022-06-08T11:18:20","date_gmt":"2022-06-08T16:18:20","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=220"},"modified":"2025-04-02T13:51:05","modified_gmt":"2025-04-02T18:51:05","slug":"back-up-sql-databases-to-google-drive","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2022\/06\/08\/back-up-sql-databases-to-google-drive\/","title":{"rendered":"Back up SQL Databases to Google Drive"},"content":{"rendered":"\n<p id=\"block-a0c957d3-ed9f-4723-8b42-7270ea3b35f4\"><strong>Looking for a straightforward way to backup SQL data to Google Drive?<\/strong> Utilizing Google Drive as a backup destination ensures your databases are stored safely offsite. Follow this quick guide to configure <strong>SQL Backup Master<\/strong> to automatically back up SQL databases to Google Drive.<\/p>\n\n\n\n<p id=\"block-7babc50f-96eb-434f-a9aa-e0cabd23e712\"><strong>STEP 1 &#8211; CREATE AND SET UP YOUR GOOGLE DRIVE ACCOUNT<\/strong><\/p>\n\n\n\n<p id=\"block-325e19e1-dc8b-4e8a-bf27-ba323ebb7af5\">Open the Google Drive homepage and sign up or log in using the account best suited for your organization\u2019s needs. Follow any prompts and provide the requested information. Ensure you have adequate storage space to hold your SQL database backups.<\/p>\n\n\n\n<p id=\"block-f8330b52-e9d9-401c-bd5d-3bfd3aca3adb\"><strong>STEP 2 &#8211; CONNECT TO SQL SERVER<\/strong><\/p>\n\n\n\n<p id=\"block-a9c6e4bc-5118-4c4d-924e-9e2b52a2395e\">Open <strong>SQL Backup Master<\/strong> and click on <strong>Backups<\/strong> in the navigation center, then select <strong>New Backup<\/strong>. The <strong>Database Backup Editor<\/strong> window will appear. Within this window, select the <strong>Choose SQL Server<\/strong> tab. The <strong>Connect to SQL Server <\/strong>window will then open.<\/p>\n\n\n\n<figure class=\"wp-block-image\" id=\"block-69b7a278-d1be-4261-a82e-4af1d3da710b\"><img decoding=\"async\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2024\/09\/DropboxBlogImage1-1.png\" alt=\"SQL Backup Master screenshot showing connection to SQL Server\"\/><\/figure>\n\n\n\n<p id=\"block-c132ead4-7ea0-43a1-8bcc-cf5263f998dc\">In the field labeled <strong>Server Name<\/strong>, select or enter the name of the <strong>SQL Server<\/strong> instance that you are connecting to. Common examples include:<\/p>\n\n\n\n<ul id=\"block-7183fbd0-5342-4d51-bf64-6eea6efc87fb\">\n<li><strong><em>(local)\\SQLExpress<\/em><\/strong> \u2013 Default SQL Express named instance on the local machine.<\/li>\n\n\n\n<li><strong><em>(local)<\/em><\/strong> \u2013 Local SQL Server installation without a named instance.<\/li>\n\n\n\n<li><strong><em>Server1\\SQLExpress<\/em><\/strong> \u2013 Default SQL Express named instance on a remote computer named \u201cServer1.\u201d<\/li>\n\n\n\n<li><strong><em>Server1<\/em><\/strong> \u2013 An unnamed SQL Server instance on a remote computer named \u201cServer1.\u201d<\/li>\n<\/ul>\n\n\n\n<p id=\"block-f22342c0-7c24-4034-9bce-a224d77428e2\"><strong>TIP<\/strong>: Use the drop-down arrow next to the <strong>Server Name<\/strong> field to discover local and remote SQL Server instances automatically.<\/p>\n\n\n\n<p id=\"block-52f5a8e3-484d-4267-8c8e-1bf3e205253a\">Click <strong>Test SQL Connection<\/strong> to confirm your connection, then click <strong>OK<\/strong>. Next, click the <strong>Save<\/strong> button (bottom-left).<\/p>\n\n\n\n<p id=\"block-8884fda0-3470-4839-842b-f407b35a0a83\">When the <strong>Windows user account configuration notice<\/strong> appears, click <strong>Yes<\/strong> to continue. Then, check <strong>Run Backup with a Specific Windows Account<\/strong> and enter your authentication credentials (typically only needed once per backup job).<\/p>\n\n\n\n<p id=\"block-64ef3165-b238-4963-aacc-4047da6883cf\"><strong>STEP 3 &#8211; SELECT DESIRED DATABASES TO BACK UP<\/strong><\/p>\n\n\n\n<p id=\"block-1b161d8b-bb07-43a6-8998-e81af4894615\">After connecting to a SQL Server instance, the <strong>Database Backup Editor<\/strong> window will list available databases under <strong>Source<\/strong>. Select all the databases you want to include in this backup job.<\/p>\n\n\n\n<p id=\"block-585e76e2-bb28-4fc2-aacb-dcef3e41e560\"><strong>TIP<\/strong>: Enable <strong>Back up all Non-System Databases<\/strong> to automatically include newly created databases on the target server going forward.<\/p>\n\n\n\n<p id=\"block-6ca62a2a-eec8-4f15-8788-90368b2d0836\"><strong>STEP 4 &#8211; ADD A GOOGLE DRIVE BACKUP DESTINATION<\/strong><\/p>\n\n\n\n<p id=\"block-070300aa-d80d-4cec-9eaa-cdd1271cb5aa\">Under the <strong>Destinations<\/strong> header in the <strong>Database Backup Editor<\/strong>, click the <strong>Add<\/strong> button. A window will appear, listing all possible backup destinations supported by SQL Backup Master.<\/p>\n\n\n\n<p id=\"block-d70425d3-b625-4631-8a21-7eeb4bc82366\">Double-click <strong>Google Drive<\/strong> (or select it and click <strong>Select<\/strong>) to choose it as your backup destination.<\/p>\n\n\n\n<figure class=\"wp-block-image\" id=\"block-913fcf8b-806c-40c3-bcdb-54ccd2ef11c4\"><img decoding=\"async\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2024\/09\/Blog1Destigoogdrive.png\" alt=\"Destination selection screen for Google Drive\"\/><\/figure>\n\n\n\n<p id=\"block-3deb9d43-f8da-4ddd-9fdc-7edb1bc38a28\">You will then see the <strong>Google Drive Destination Settings<\/strong> window, where you can authorize a connection to your Google Drive account.<\/p>\n\n\n\n<figure class=\"wp-block-image\" id=\"block-36ab027a-08a8-4bbe-bf10-6106804d9a29\"><img decoding=\"async\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2024\/09\/DropboxBlogImage3-1.png\" alt=\"SQL Backup Master Google Drive authorization prompt\"\/><\/figure>\n\n\n\n<p id=\"block-1b14596d-72b1-4563-a89a-b8098da91ca2\">Select <strong>Authorize Now<\/strong> and sign in with your Google Drive credentials. Follow the prompts to grant <strong>SQL Backup Master<\/strong> permission to upload backup files to your Google Drive. You should see confirmation screens during the authorization process:<\/p>\n\n\n\n<figure class=\"wp-block-image\" id=\"block-c3ccb344-11b9-47f9-92ea-462a07985737\"><img decoding=\"async\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2024\/09\/Blog2GoogDriveAccount1-1024x383.png\" alt=\"Authorize Google Drive account for SQL Backup Master\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\" id=\"block-091a5e48-215c-4539-afe1-15915065abd5\"><img decoding=\"async\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2024\/09\/Blog2GoogDriveAccount2-1024x489.png\" alt=\"Granting permission for SQL Backup Master\"\/><\/figure>\n\n\n\n<p id=\"block-11779f6e-facf-460c-ae76-a8176016f95c\">Click <strong>Continue<\/strong> when prompted. Once authorization is successful, you should see a confirmation screen similar to this:<\/p>\n\n\n\n<figure class=\"wp-block-image\" id=\"block-e5762982-857c-4e1d-9c39-bd32a43597c6\"><img decoding=\"async\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2024\/09\/2024-09-27_23-06-49-1024x198.png\" alt=\"Successful Google Drive authorization\"\/><\/figure>\n\n\n\n<p id=\"block-ae791f02-d5cf-41e5-a8ed-2dd4cd1a4896\"><strong>STEP 5 &#8211; RUN THE BACKUP JOB<\/strong><\/p>\n\n\n\n<p id=\"block-595448ff-ba57-41d1-9824-a3e565cc2559\">Return to the main window in SQL Backup Master, select your newly created backup job, and hit <strong>Back up now<\/strong> to begin backing up your databases to Dropbox. If the backup job does not complete successfully, consult the log file for more details on any errors.<\/p>\n\n\n\n<p id=\"block-a9f24ddb-af3a-4e49-95df-8605d030f314\">If the backup job doesn\u2019t complete successfully, review the application log file for error details or additional troubleshooting information.<\/p>\n\n\n\n<p id=\"block-11ff42a4-7a7b-44ba-816f-4ff613588a24\"><strong>That\u2019s it!<\/strong> You are now backing up your SQL database to Google Drive. By automating backups with <strong>SQL Backup Master<\/strong>, you\u2019ll have peace of mind knowing your critical data is protected offsite and readily available for recovery.<\/p>\n\n\n\n<p id=\"block-6e9e2dcd-0833-4ef1-83d1-1ef0c6b969f1\"><em>If you\u2019re looking for additional backup destinations\u2014such as Dropbox, OneDrive, or Amazon S3\u2014be sure to explore the full feature set of SQL Backup Master by Key Metric Software.<\/em><\/p>\n\n\n\n<h3><strong>STEP 1 \u2013 GOOGLE DRIVE ACCOUNT CREATION AND SETUP<\/strong><\/h3>\n\n\n\n<p>To create a Google Drive account, navigate to the <a href=\"https:\/\/www.google.com\/drive\/\">Google Drive home page<\/a> and select the <strong>Sign up at no cost<\/strong> option near just under the <strong>Go to Drive<\/strong> button.&nbsp;<\/p>\n\n\n\n<p>Next, enter your contact information and required credentials to create your account. Once your account is created, you will be taken to the <strong>Google Drive<\/strong> main page.<\/p>\n\n\n\n<h3><strong>STEP 2 \u2013 CONNECT YOUR SQL SERVER<\/strong><\/h3>\n\n\n\n<p>In <strong>SQL Backup Master<\/strong>, navigate to the <strong>Backup and Restore <\/strong>tab, here select the <strong>New Backup <\/strong>button. Then the <strong>Database Backup Editor <\/strong>window will open, select the tab labeled <strong>Choose SQL Server. <\/strong>This will bring up the <strong>Connect to SQL Server <\/strong>window:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"500\" height=\"396\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-connect-3.png\" alt=\"\" class=\"wp-image-337\" srcset=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-connect-3.png 500w, https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-connect-3-300x238.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure>\n\n\n\n<p>In the <strong>Server name <\/strong>field, enter or select the name of the SQL Server instance that you are going to connect to. Common examples include:<\/p>\n\n\n\n<ul>\n<li><strong><em>(local)\\SQLExpress<\/em><\/strong> \u2013 Specifies the default SQL Express named instance on the local computer.<\/li>\n\n\n\n<li><strong><em>(local)<\/em><\/strong> \u2013 Specifies the local SQL Server installation (without an instance name).<\/li>\n\n\n\n<li><strong><em>Server1\\SQLExpress<\/em><\/strong><strong> <\/strong>\u2013 Specifies the default SQL Express names instance on a remote computer named \u201cServer1\u201d.<\/li>\n\n\n\n<li><strong><em>Server1<\/em><\/strong> \u2013 Specifies an unnamed SQL Server instance on a remote computer named \u201cServer1\u201d.<\/li>\n<\/ul>\n\n\n\n<p>Use the <strong>Test SQL Connection<\/strong> button to test your connection, then hit <strong>Ok<\/strong>.<\/p>\n\n\n\n<h3><strong>STEP 3 \u2013 SELECT DATABASES TO BACK UP<\/strong><\/h3>\n\n\n\n<p>Once you\u2019ve properly connected to a SQL Server instance, the <strong>Database Backup Editor<\/strong> window will display all available databases under the <strong>Source<\/strong> label. Select the database(s) you want to include in this backup job<\/p>\n\n\n\n<p>Checking the box labeled <strong>Back up all non-system databases <\/strong>will back up all new databases created on the target SQL Server in the future automatically.<\/p>\n\n\n\n<h3><strong>STEP 4 \u2013 ADD A BACKUP DESTINATION<\/strong><\/h3>\n\n\n\n<p>Click the<strong> <\/strong>button labeled <strong>Add <\/strong>under the window header labeled <strong>Destinations.<\/strong> This will bring up a window displaying all compatible backup destinations for your SQL Database:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"600\" height=\"595\" src=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-choose-backup-dest-3.png\" alt=\"\" class=\"wp-image-338\" srcset=\"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-choose-backup-dest-3.png 600w, https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-choose-backup-dest-3-300x298.png 300w, https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-content\/uploads\/2023\/05\/sql-choose-backup-dest-3-150x150.png 150w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>Choose Google Drive by double-clicking the <strong>Google Drive <\/strong>selection box.<\/p>\n\n\n\n<p>After choosing Google Drive as your destination, the <strong>Google Drive Destination Settings <\/strong>window will appear. This is where you establish a connection to Google Drive. Click on the <strong>Authorize Now<\/strong> button and input your Google login information on the new window.&nbsp;<\/p>\n\n\n\n<p>Signing in to your Google account through the browser will bring up the following window:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/MMR-lqnEbPbF7K78Vi1LTPR82jrU5Jmvgcn90jurRErJ4kB0yDIW8BdB3WupHOMOoUtSDEdvpGrhBXsItn_YuBBbR5Ek_DxkE70yggsfVqPDZ_A7nAk3-hQ033BNKnWIKgsI405N-2vG6yKjwA\" alt=\"\"\/><\/figure><\/div>\n\n\n<p>Select the <strong>Allow <\/strong>option then close the window to continue.<\/p>\n\n\n\n<p>You can use the <strong>Test <\/strong>button in the bottom left corner of the <strong>Google Drive Destination Settings <\/strong>window to verify that you have a successful connection to your desired Google account, select <strong>Ok<\/strong>, then click the <strong>Ok <\/strong>button on the main window to continue.&nbsp;<\/p>\n\n\n\n<p>Back at the bottom right corner of the<strong> Database Backup Editor <\/strong>window, use the <strong>Save <\/strong>button to establish your backup destination.&nbsp;<\/p>\n\n\n\n<h3><strong>STEP 5 \u2013 RUN THE BACKUP JOB<\/strong><\/h3>\n\n\n\n<p>Back in the<strong> <\/strong>main window of the application, select your newly created backup job and use the <strong>Back up now<\/strong> button to begin backing up your SQL Server to your Google Drive.<\/p>\n\n\n\n<p>If the backup job does not complete successfully, please review the log file for further details on the failure.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Looking for a straightforward way to backup SQL data to Google Drive? Utilizing Google Drive as a backup destination ensures your databases are stored safely offsite. Follow this quick guide to configure SQL Backup Master to automatically back up SQL databases to Google Drive. STEP 1 &#8211; CREATE AND SET UP YOUR GOOGLE DRIVE ACCOUNT [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/220"}],"collection":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/comments?post=220"}],"version-history":[{"count":11,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/220\/revisions"}],"predecessor-version":[{"id":538,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/220\/revisions\/538"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}