{"id":29,"date":"2016-07-06T12:33:02","date_gmt":"2016-07-06T17:33:02","guid":{"rendered":"http:\/\/www.sqlbackupmaster.com\/wordpress\/?p=29"},"modified":"2025-04-02T10:12:55","modified_gmt":"2025-04-02T15:12:55","slug":"how-to-back-up-sql-server-database-to-an-ftp-server","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2016\/07\/06\/how-to-back-up-sql-server-database-to-an-ftp-server\/","title":{"rendered":"Back Up SQL Server Databases to an FTP Server"},"content":{"rendered":"\n

Looking for a quick way to back up SQL to FTP?<\/strong> With SQL Backup Master<\/strong>, you can easily automate and schedule backups to standard FTP, FTPS (TLS\/SSL), or SFTP servers. Follow the steps below to configure and run your backup job, ensuring your data is kept safe offsite.<\/p>\n\n\n\n

Step 1 – Create a Backup Job<\/strong><\/h2>\n\n\n\n

In the main SQL Backup Master<\/strong> window, select the Backup and Restore<\/strong> tab, then click the Create new database backup<\/strong> toolbar button. The Database Backup Editor<\/strong> window will appear.<\/p>\n\n\n\n

Give your backup job a unique name (and optionally a description). This makes it easier to identify in the future.<\/p>\n\n\n\n

Step 2 – Connect to SQL Server<\/strong><\/h2>\n\n\n\n

In the Database Backup Editor<\/strong> window, click the Choose SQL Server<\/strong> button. This will open the Connect to SQL Server<\/strong> dialog box:<\/p>\n\n\n\n

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

In the Server name<\/strong> field, enter or select the name of the SQL Server instance to which you\u2019re connecting. 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 The 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

    TIP<\/strong>: You can also use the drop-down arrow of the Server name<\/strong> field to discover local and remote SQL Server instances. When ready, click Test SQL Connection<\/strong> to verify connectivity, then hit OK<\/strong>.<\/p>\n\n\n\n

    Step 3 – Select Databases to Back Up<\/strong><\/h2>\n\n\n\n

    Once you\u2019re connected, the Database Backup Editor<\/strong> window displays a list of databases. Check the boxes for the databases you want to include in this backup job.<\/p>\n\n\n\n

    If you enable the Back up all non-system databases<\/strong> option, any new database created on the target SQL Server in the future will be included in backups automatically.<\/p>\n\n\n\n

    Step 4 – Add an FTP Server Backup Destination<\/strong><\/h2>\n\n\n\n

    Under the Destinations<\/strong> heading in the Database Backup Editor<\/strong>, click the Add<\/strong> toolbar button. The Choose Destination<\/strong> window will appear. Double-click FTP Server<\/strong> to proceed.<\/p>\n\n\n\n

    The FTP Destination Settings<\/strong> window will open. Provide details about the FTP server you want to use (such as the server host address, username, and password). You can also configure advanced settings for FTPS<\/strong>, SFTP<\/strong> (via SSH), or specific proxy options like SOCKS4<\/strong> or SOCKS5<\/strong>.<\/p>\n\n\n\n

    \"Back<\/figure>\n\n\n\n

    Click the Test<\/strong> button to ensure SQL Backup Master can connect and upload to your FTP server. Once configured, click OK<\/strong> to return to the Database Backup Editor<\/strong> window. Finally, select Save<\/strong> to store your new backup configuration.<\/p>\n\n\n\n

    Congratulations!<\/strong> You\u2019ve successfully configured your first SQL Server database backup using SQL Backup Master and an FTP Server destination.<\/p>\n\n\n\n

    Step 5 – Run the Backup Job<\/strong><\/h2>\n\n\n\n

    Back in the main application window, locate your newly created backup job and click Back up now<\/strong> to begin the process. If the job does not complete successfully, check the log file for detailed error information.<\/p>\n\n\n\n

    That\u2019s it!<\/strong> You are now backing up your SQL database to FTP. 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 a quick way to back up SQL to FTP? With SQL Backup Master, you can easily automate and schedule backups to standard FTP, FTPS (TLS\/SSL), or SFTP servers. Follow the steps below to configure and run your backup job, ensuring your data is kept safe offsite. Step 1 – Create a Backup Job […]<\/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\/29"}],"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=29"}],"version-history":[{"count":14,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":536,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/29\/revisions\/536"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}