SQLBackupAndFTP database automatic backup software tutorial

Source: Internet
Author: User
Tags temporary file storage sql server express

SQLBackupAndFTP is mainly used to automatically back up the database, restore the database with one click, send the backup database log report to the mailbox, automatically compress the backed up database, and regularly execute Database Backup tasks to replace the SSMS maintenance plan, upload database backup files to the FTP server 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

It is particularly 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 solve this problem by using SQLBackupAndFTP.

SQLBackupAndFTP:

Installation path: C: Program FilesPranas. NETSQLBackupAndFTP

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.

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: MSSQLDatabackup.

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: MSSQLDatabackup

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

The size of the backup file is 5.1 MB, which is 886KB after compression. The compression ratio is high.

Restore database with one click

Click "Restore ".

Select the path of the Database Backup File

If the database is in use, he will ask if you want to terminate all processes of the database.

Click "yes"

Restored successfully

Main function limitations

Scheduled tasks only support two databases. However, these restrictions do not affect o (scheduled _ tasks) o.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.