Please follow this link to download graphic materials.
SQLBackupAndFTP application (SBF) communicates with https://api.sqlbak.com – below are the details. At no point any of the passwords or secret keys are being sent to SQLBackupAndFTP servers. Still, you may want to know what information is being exchanged in order to understand that your security and privacy is not compromised or to configure your firewall or proxy server if any issues arise.
Firewall configuration considerations
SBF connects to api.sqlbak.com web server to upload the data as described below. If there is an issue connecting to api.sqlbak.com – make sure that “SQLBackupAndFTP (SQL Server backup)” Windows service can connect to api.sqlbak.com:443. If the app connects to Internet through a Proxy server, you can set up Proxy server settings in the Tools -> Proxy Settings menu.
When a user installs SBF and runs it for the first time, the app posts a request to api.sqlbak.com to register the installation and activate a Professional Trial license. The app requests api.sqlbak.com server in few times in a day to validate the Professional Trial license.
When a user enters a license key into SBF, the app posts a request to api.sqlbak.com to register the license for the installed app. The app requests api.sqlbak.com server in few times in a day to validate the current license. If SBF can not validate a license at least once in 24 hours, the license is downgraded to the Free edition.
SBF can show text and graphics with ads, notifications or announcements at the bottom of the main window. The app requests api.sqlbak.com server in few times in a day to request such content (if any). This feature does not throw an error the Internet connection is missing.
Automatic email feature
When user sends email via our servers using “Automatic/Zero-config” option (default for trials and paid editions with active subscriptions) – SBF communicates with api.sqlbak.com to upload backup log. These log records do not contain passwords or secret keys.
See backup history on the web option
When “See backup history on the web” option is ON (in Backup Settings section – available for trials and paid editions with active subscriptions), SBF requests api.sqlbak.com to store the log records on sqlbackupandftp.com server. These log records do not contain passwords or secret keys.
Users may want to enable writing advanced log into a temporary file and send this file to SQLBackupAndFTP developer team. SBF does not send this file automatically. You can enable and send it to us using the main menu: Tools -> Advanced Log. This file does not contain passwords or secret keys.
When SBF encounters an error, SBF requests api.sqlbak.com server to send the error information including error text and stack trace. The error information does not contain passwords or secret keys.
SBF requests api.sqlbak.com server to check the app for updates. The app is updated automatically if the new version is available for the license used and “Automatically download and install updates” option in settings is ON.
SQL down alert
When “Service down alert” option is ON and the connected server is not available (like service stopped), SBF requests api.sqlbak.com server to send an email notification. SBF also sends “Keep Alive” requests to api.sqlbak.com web service (if this option is ON).
SBF connects to a database server (local or remote) – whatever is specified in your job. If a remote connection is specified, your firewall may need to be configured to allow such connection.
SBF connects to destinations for uploading database backups – Network, FTP server, Dropbox, Amazon S3, etc – whatever is specified in your job. If a remote connection is specified, your firewall may need to be configured to allow such connection.
In that blog post let’s talk about one of the crucial questions in the life of every DBA it is SQL Server database backup and restores process, which you can cover using backup and restore utility SQLBackupAndFTP. You can install this tool on your machine or personal computer and it will do all work for you. So here is a short tutorial how you can protect your SQL Server database using backup and restore utility. More…
In this post, we are planning to talk about how to make SQL Server backup system databases. The easiest way is to use the simple tool – SQLBackupAndFTP. Planning the backup process should really be one of the points that are crucial in the life of any DBA.
Such simple procedure will definitely save you tons of time and effort in the future. More…
If you are looking for a tool to backup and restore SQL database then use simple tool SQLBackupAndFTP. The most typical jokes you’ll discover when mentioning about one particular important responsibility for a DBA goes like this – a Database Administrator requires one of two things, a great backup or an ideal resume. It’s real. If you’re not performing backups and making sure that you can recover databases from those backups, you’re exposing yourself and your company to information loss. More…
The best way to backup and restore in SQL Server is use SQLBackupAndFTP. Probably one of the most frequent jokes you will hear while mentioning over probably the essential jobs for a Database Administrator goes like this – a Database Administrator needs one of two things, an ideal backup or a good resume. It’s truthful. If you’re not performing backups and making sure that you can restore databases from those backups, you’re exposing yourself and your company to files loss. More…
A process, which called backup and recovery in SQL Server is crucial for your data. Use SQLBackupAndFTP to make scheduled backups and use One-Click SQL Restore to restore your full backups. Do you really have to make backup and recovery in SQL Server? Certainly. Unless you don’t care about your data or you don’t mind having to fully recreate your database in the event of a disaster, you need a way of restoring the database to a usable point. There are numerous ways how to perform Backup and Recovery in SQL Server, but the simplest is to use SQLBackupAndFTP application. More…
You can simply backup SQL Server with the help of SQLBackupAndFTP tool and in the case of failure, these backups can be restored with the “Restore” option. Using SQLBackupAndFTP you can simply restore backups that were made with this tool, or with T-SQL command “CREATE BACKUP”, or SQL script, or a .bacpac container. More…
To keep data protected make backups regularly use SQLBackupAndFTP this is free download backup software. In a perfect world we would never have to care about our machines failing, nor would we have to worry about failure. But we do not live in an ideal world so be sure to backup data regularly. You can keep data secure by using SQLBackupAndFTP. More…