SQL Server database automatic backup tool SQLBackupAndFTP (comprehensive functions)

The SQL Server database automatic backup tool SQLBackupAndFTP (fully functional) is mainly used to automatically back up the database, restore the database with one click, and send the backup database log report to the mailbox, automatically compress the backed up database to regularly execute Database Backup tasks, replace the SSMS maintenance plan, and upload the database backup files to the FTP server.

The SQL Server database automatic backup tool SQLBackupAndFTP (fully functional) is mainly used to automatically back up the database, restore the database with one click, and send the backup database log report to the mailbox, automatically compress the backed up database to regularly execute Database Backup tasks, replace the SSMS maintenance plan, and upload the database backup files to the FTP server.

SQL Server database automatic backup tool SQLBackupAndFTP (comprehensive functions)

This tool is mainly used to automatically back up the database, restore the database with one click, send the backup database log report to the mailbox, and automatically compress the backed up database

Regularly executes Database Backup tasks, replaces SSMS maintenance plans, and uploads database backup files to FTP servers and other network hard disks.

The software has two modes: free and paid, but I think the functions of the free version are sufficient.

Supported SQLSERVER versions: SQLSERVER2000, SQLSERVER2005, SQLSERVER2008, SQLSERVER2008 R2, and SQLSERVER2012

This is especially useful when your computer is SQL Server Express 2005 and SQL Server Express 2008.

Because the SQLSERVER Express version has no maintenance plan, you can use SQLBackupAndFTP to solve this problem.

This tool also has the MYSQL version.

MYSQL version:

SQLSERVER Azure Special Edition:

Official Website:

Installation path: C: \ Program Files \ Pranas. NET \ SQLBackupAndFTP

The installation directory contains some DLL files.

SQLBackupAndFTP creates a new Windows service to regularly back up the database and replace the SSMS maintenance plan,

The database backup software developed by our company also uses the Windows service to regularly back up the database. In fact, the principles of these software are similar.

Looking at the pictures above, I believe that people who want to crack this software are starting to be confused, but it is best not to crack it and respect others.

You can use the free version. It is best not to crack the paid feature.

About the Xceed Zip for. NET component:

Some settings

First, set the database connection

Check the database to be backed up

Set the email and send the backup report to the email address.

Set a scheduled task. You can set full backup, differential backup, and transaction log backup,

You can also set whether to use the system task plan to run the scheduled task or use the software Windows service to run the task.

The software has preset some timing options and you can click them to apply them.

Set backup options, including temporary file storage path for large databases, compressed backup file options, whether to verify backup files, backup database log storage path, encrypted backup files (charged)

I set the path of the backup database log and large temporary database files to D: \ MSSQL \ Databackup.

After setting the backup path, you also need to go back to the main interface to set the backup path. Backup database files can be uploaded to the FTP server, DROPBOX, SKYDRIVE (pay-as-you-go), etc.

I put the backup file in the same path as the backup database log D: \ MSSQL \ Databackup

The software can also set how long ago the backup files were automatically deleted, and back up the files to remote paths and NAS storage,

For the network path, click "Test" to Test connectivity.

Set FTP

After all the settings are complete, you can save the configuration. When you reinstall the software or change the machine, you do not need to set it again.

Export the configuration file

After the backup is set, click "run now" to manually execute the backup. Then, the Database Backup will be performed according to the Setting Plan in the scheduled task settings.

Open the mailbox and you will see the email.

You can view logs and compressed backup files in the path.

Logs