Category Archives: MISC

What data SQLBackAndFTP sends to the server?

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.

Licensing

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.

Notification

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.

Advanced log

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.

Error statistics

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.

Update

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).

Database Servers

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.

Destinations

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.

 

Backup and Restore Utility SQLBackupAndFTP

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. Continue reading Backup and Restore Utility SQLBackupAndFTP

SQL Server Backup System Databases

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. Continue reading SQL Server Backup System Databases

Backup And Restore SQL Database

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. Continue reading Backup And Restore SQL Database

Backup and Restore in SQL Server

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. Continue reading Backup and Restore in SQL Server

Backup and Recovery in SQL Server

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. Continue reading Backup and Recovery in SQL Server