{"id":222,"date":"2022-06-07T20:22:02","date_gmt":"2022-06-08T01:22:02","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=222"},"modified":"2025-04-06T07:12:00","modified_gmt":"2025-04-06T12:12:00","slug":"backup-sql-databases-to-google-cloud-storage","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2022\/06\/07\/backup-sql-databases-to-google-cloud-storage\/","title":{"rendered":"Back up SQL Databases to Google Cloud Storage"},"content":{"rendered":"\n

Need an efficient way to back up SQL to Google Cloud Storage?<\/strong> With SQL Backup Master<\/strong>, you can quickly configure, automate, and maintain secure offsite backups for your SQL Server databases. Follow the steps below to set up Google Cloud Storage (GCS) as your backup destination.<\/p>\n\n\n\n

STEP 1 \u2013 GOOGLE CLOUD STORAGE ACCOUNT SETUP<\/strong><\/h3>\n\n\n\n

Start by navigating to the Google Cloud Storage homepage<\/a> and selecting either Get started for free<\/strong> or Try Storage free<\/strong>. You\u2019ll be asked to provide company credentials and a phone number as part of Google\u2019s verification process.<\/p>\n\n\n\n

STEP 2 \u2013 CONNECT SQL SERVER DATABASE<\/strong><\/h3>\n\n\n\n

In the Backup and Restore<\/strong> window of SQL Backup Master<\/strong>, click New Backup<\/strong>. The Database Backup Editor<\/strong> window will appear. Select Choose SQL Server<\/strong> to open the Connect to SQL Server<\/strong> dialog.<\/p>\n\n\n\n

\"SQL<\/figure>\n\n\n\n

In the Server name<\/strong> field, enter or select the name of your SQL Server instance. Common examples include:<\/p>\n\n\n\n

    \n
  • (local)\\SQLExpress<\/em><\/strong> \u2013 The default SQL Express named instance on the local computer.<\/li>\n\n\n\n
  • (local)<\/em><\/strong> \u2013 A local SQL Server installation without an instance name.<\/li>\n\n\n\n
  • Server1\\SQLExpress<\/em><\/strong> \u2013 The default SQL Express named instance on a remote computer named \u201cServer1.\u201d<\/li>\n\n\n\n
  • Server1<\/em><\/strong> \u2013 An unnamed SQL Server instance on a remote computer named \u201cServer1.\u201d<\/li>\n<\/ul>\n\n\n\n

    Click the Test SQL Connection<\/strong> button to confirm connectivity; then select OK<\/strong>.<\/p>\n\n\n\n

    STEP 3 \u2013 SELECT DESIRED DATABASES TO BACK UP<\/strong><\/h3>\n\n\n\n

    After connecting, the Database Backup Editor<\/strong> window will list your available databases under Source<\/strong>. Check the databases you want to back up as part of this job.<\/p>\n\n\n\n

    TIP<\/strong>: Enable Back up all non-system databases<\/strong> to automatically include any newly created databases on the target SQL Server in subsequent backups.<\/p>\n\n\n\n

    STEP 4 \u2013 ADDING A BACKUP DESTINATION<\/strong><\/h3>\n\n\n\n

    Under the Destinations<\/strong> header, click the Add<\/strong> icon. A window will appear, displaying compatible backup destinations supported by SQL Backup Master:<\/p>\n\n\n\n

    \"SQL<\/figure>\n\n\n\n

    Double-click Google Cloud Storage<\/strong> to select it as your backup destination. The Google Cloud Storage Destination Settings<\/strong> window will appear, prompting you to enter your Access key<\/strong>, Secret key<\/strong>, and Bucket<\/strong>. You can generate these keys from your Google Cloud project credentials.<\/p>\n\n\n\n

    Click the Test<\/strong> button to verify that SQL Backup Master can connect to your GCS bucket. Select OK<\/strong>, then confirm once more on the main window to continue. Finally, click the Save<\/strong> icon at the bottom-right of the Database Backup Editor<\/strong> to finalize your backup destination.<\/p>\n\n\n\n

    STEP 5 \u2013 RUN THE BACKUP<\/strong><\/h3>\n\n\n\n

    Return to the main SQL Backup Master<\/strong> window, locate your new backup job, and click Back up now<\/strong> to begin sending your SQL Server databases to Google Cloud Storage<\/strong>. If the backup job fails, consult the log file for more detailed information on any errors.<\/p>\n\n\n\n

    That\u2019s it! You can now safeguard your SQL Server data offsite by leveraging the reliability of Google Cloud Storage\u2014powered by SQL Backup Master from Key Metric Software.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Need an efficient way to back up SQL to Google Cloud Storage? With SQL Backup Master, you can quickly configure, automate, and maintain secure offsite backups for your SQL Server databases. Follow the steps below to set up Google Cloud Storage (GCS) as your backup destination. STEP 1 \u2013 GOOGLE CLOUD STORAGE ACCOUNT SETUP Start […]<\/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\/222"}],"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=222"}],"version-history":[{"count":10,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"predecessor-version":[{"id":540,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/222\/revisions\/540"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}