{"id":218,"date":"2022-06-08T11:30:47","date_gmt":"2022-06-08T16:30:47","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=218"},"modified":"2025-04-01T07:33:48","modified_gmt":"2025-04-01T12:33:48","slug":"back-up-sql-server-databases-to-amazon-s3","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2022\/06\/08\/back-up-sql-server-databases-to-amazon-s3\/","title":{"rendered":"Back Up SQL Databases to Amazon S3"},"content":{"rendered":"\n

Need a streamlined way to back up SQL to Amazon S3?<\/strong> With SQL Backup Master<\/strong>, you can quickly automate backups and securely store your databases in Amazon\u2019s cloud. Follow the steps below to configure your Amazon S3 account, connect to SQL Server, and create a reliable offsite backup solution.<\/p>\n\n\n\n

STEP 1 \u2013 AMAZON S3 ACCOUNT CREATION AND SETUP<\/strong><\/h3>\n\n\n\n

To create an Amazon S3 account, navigate to Amazon\u2019s AWS home page<\/a> and select Get Started with Amazon S3<\/strong>. Click the Create a new AWS account<\/strong> button below the login field, then follow the on-screen instructions to set up and verify your new AWS account.<\/p>\n\n\n\n

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

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

\"Connect<\/figure>\n\n\n\n

Enter the name of the SQL Server instance you\u2019re connecting to in the Server name<\/strong> field. Common examples include:<\/p>\n\n\n\n

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

    You can also use the drop-down arrow in the Server name<\/strong> field to detect local and 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 DESIRED DATABASES TO BACK UP<\/strong><\/h3>\n\n\n\n

    Now that you\u2019re connected, the Database Backup Editor<\/strong> window will display all available databases under Source<\/strong>. Check the boxes for the databases you wish to include in this backup job.<\/p>\n\n\n\n

    Alternatively, enable Back up all non-system databases<\/strong> to automatically include any new databases created on your SQL Server over time.<\/p>\n\n\n\n

    STEP 4 \u2013 CHOOSE S3 AS YOUR BACKUP DESTINATION<\/strong><\/h3>\n\n\n\n

    Under the Destinations<\/strong> header in the Database Backup Editor<\/strong>, click the Add<\/strong> button to specify where your backups will be stored. A new window will appear, listing compatible backup destinations:<\/p>\n\n\n\n

    \"Choosing<\/figure>\n\n\n\n

    Double-click Amazon S3<\/strong>. The Amazon S3 Destination Settings<\/strong> window will then open. This is where you\u2019ll configure your S3 credentials.<\/p>\n\n\n\n

    Retrieve your Access key<\/strong> and Secret key<\/strong> from the Security Credentials<\/strong> section of your AWS Management Console, and paste them into the corresponding fields in SQL Backup Master. Enter the name of your existing S3 Bucket<\/strong> in the third field. Once you\u2019ve filled in the details, click Test<\/strong> to confirm a successful connection, and then select OK<\/strong>.<\/p>\n\n\n\n

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

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

    Return to the main SQL Backup Master window, select your newly created backup job, and click Back up now<\/strong> to begin sending your SQL Server databases to Amazon S3<\/strong>.<\/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 Amazon S3. 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 Google Drive\u2014be sure to explore the full feature set of SQL Backup Master by Key Metric Software.<\/em><\/p>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Need a streamlined way to back up SQL to Amazon S3? With SQL Backup Master, you can quickly automate backups and securely store your databases in Amazon\u2019s cloud. Follow the steps below to configure your Amazon S3 account, connect to SQL Server, and create a reliable offsite backup solution. STEP 1 \u2013 AMAZON S3 ACCOUNT […]<\/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\/218"}],"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=218"}],"version-history":[{"count":16,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":529,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/218\/revisions\/529"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}