{"id":228,"date":"2022-06-08T11:40:05","date_gmt":"2022-06-08T16:40:05","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=228"},"modified":"2025-04-01T07:00:43","modified_gmt":"2025-04-01T12:00:43","slug":"how-to-backup-up-sql-server-to-backblaze","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2022\/06\/08\/how-to-backup-up-sql-server-to-backblaze\/","title":{"rendered":"Back Up SQL Databases to Backblaze"},"content":{"rendered":"\n

Looking for an easy way to back up SQL data to Backblaze?<\/strong> With SQL Backup Master<\/strong> and Backblaze B2<\/strong> cloud storage, you can automate and secure your SQL Server backups in just a few steps. Follow the guide below to set up and run your backup job.<\/p>\n\n\n\n

STEP 1 \u2013 Backblaze Account Setup<\/strong><\/h3>\n\n\n\n

Go to the Backblaze B2 homepage<\/a> and click the Sign Up<\/strong> button to create an account. You\u2019ll only need to provide an email address and password to proceed. Once logged in, you\u2019ll be ready to create storage buckets for your SQL backups.<\/p>\n\n\n\n

STEP 2 \u2013 CONNECTING TO A SQL SERVER DATABASE<\/strong><\/h3>\n\n\n\n

In SQL Backup Master<\/strong>, open the Backup and Restore<\/strong> window and select New Backup<\/strong>. When the Database Backup Editor<\/strong> window appears, click the Choose SQL Server<\/strong> tab to bring up the Connect to SQL Server<\/strong> window.<\/p>\n\n\n\n

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

In the Server name<\/strong> field, type or select the name of the SQL Server instance you\u2019re backing up. 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 (no 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

    Use the drop-down arrow in the Server name<\/strong> field to automatically find local or remote SQL Server instances. Click Test SQL Connection<\/strong> to verify connectivity, then select OK<\/strong>.<\/p>\n\n\n\n

    STEP 3 \u2013 Select Databases to Back Up<\/strong><\/h3>\n\n\n\n

    After connecting, the Database Backup Editor<\/strong> window will list available databases under Source<\/strong>. Check the boxes for the databases you want to include in this backup job.<\/p>\n\n\n\n

    Enable Back up all non-system databases<\/strong> if you\u2019d like new databases to be automatically added to future backups on this SQL Server.<\/p>\n\n\n\n

    STEP 4 \u2013 Add a Backblaze B2 Backup Destination<\/strong><\/h3>\n\n\n\n

    Click the Add<\/strong> icon under Destinations<\/strong>. A window listing possible backup destinations will appear:<\/p>\n\n\n\n

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

    Double-click Backblaze B2<\/strong>. The Backblaze B2 Destination Settings<\/strong> window will appear, prompting you to authorize SQL Backup Master\u2019s connection to your Backblaze account. Enter your Access Key<\/strong>, Secret Key<\/strong>, and choose your Bucket<\/strong>. Use the Test<\/strong> button to confirm a successful connection.<\/p>\n\n\n\n

    Back at the Database Backup Editor<\/strong> window, click the Save<\/strong> icon to finalize your backup destination.<\/p>\n\n\n\n

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

    In the main SQL Backup Master window, locate your newly created backup job and click Back up now<\/strong> to begin sending your SQL backups to Backblaze B2.<\/p>\n\n\n\n

    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

    That\u2019s it!<\/strong> You are now backing up your SQL database to Backblaze. By automating backups with 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

    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","protected":false},"excerpt":{"rendered":"

    Looking for an easy way to back up SQL data to Backblaze? With SQL Backup Master and Backblaze B2 cloud storage, you can automate and secure your SQL Server backups in just a few steps. Follow the guide below to set up and run your backup job. STEP 1 \u2013 Backblaze Account Setup Go to […]<\/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\/228"}],"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=228"}],"version-history":[{"count":15,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/228\/revisions"}],"predecessor-version":[{"id":522,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/228\/revisions\/522"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}