Easy-to-use SQL Server database Automatic Backup tool SQLBACKUPANDFTP (full featured)

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

Reprint: http://www.cnblogs.com/lyhabc/p/3322437.html

It's good. SQL Server database Automatic Backup tool SQLBACKUPANDFTP (full featured)

The main tool is to automatically back up the database, one-click Restore database, send backup database log report to the mailbox, automatically compress the backup good database

Perform database backup tasks regularly, replace SSMS maintenance plan, upload database backup files to FTP server, other network hard drives, etc.

The software has free and paid two modes, but I think the free version of the function is enough

Supports SQL Server version: SQLSERVER2000, SQLSERVER2005, SQLSERVER2008, SQLSERVER2008 R2, SQLSERVER2012

Especially useful when your PC is SQL Server Express 2005 and SQL Server Express version 2008

Because SQL Server Express version does not have a maintenance plan, using SQLBACKUPANDFTP can solve this problem

This tool also has a MySQL version

MySQL version:http://mysqlbackupftp.com/download/

SQL Server Azure Special Edition:Http://files.cnblogs.com/lyhabc/SqlBakSetupAzure.rar

Official website:http://sqlbackupandftp.com/

Installation path: C:\Program files\pranas.net\sqlbackupandftp

The installation directory is primarily a number of DLLs

SQLBACKUPANDFTP will create a new Windows service to periodically back up the database to replace the SSMS maintenance plan.

The database backup software developed by our company is also the way of using Windows services to back up the database regularly, in fact, the principle of these software is almost

See the above pictures, I believe that the people who want to crack the software began to stir, but it is best not to crack, respect for others

You can use the free version, it's best not to hack his pay function

About Xceed Zip for. NET components:http://www.cnblogs.com/netflu/archive/2006/03/17/352252.html

Some setup options

First set up the database connection

Check the database you want to back up

Set up a message to send the backup report to the mailbox

Set up Scheduled Tasks, you can set up full backups, differential backups, transaction log backups,

You can also set whether to run a scheduled task using a system task schedule or a Windows service that uses software to run

The software itself also presets some timing options, with a mouse click can be applied

Set backup options, including large database temporary file storage path, compress backup file option, verify backup file, backup database log storage path, encrypt backup file (charge)

I set the backup database log and the path of the large database temp file to D:\MSSQL\Databackup

After setting the backup path above, you also need to return to the main interface to set up the backup path, the backup database file can be uploaded to the FTP server, dropbox,skydrive (to pay), etc.

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

The software can also set the automatic deletion of how long the previous backup files can also be backed up to the remote path, on the NAS storage,

If it is a network path, you can click the "Test" button to test whether it is connected

Set up FTP

After all set up can save the configuration, when the software is re-installed, or changed the machine will not have to set up

Export Configuration file

After Setup, you can click the "Run Now" button to perform the backup manually, and then follow the scheduled task settings to perform the database backup operation.

Open the mailbox and you'll see the mail.

You can see the log and the compressed backup file under the path

Log

View Code

You can see the backup file size is 5.1MB, after compression is 886KB, the compression ratio is very high

Restore a database with one click

Click the Restore button

Select the path to 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"

Restore succeeded

Main functional Limitations

The scheduled task only supports 2 databases, but these feature limits are not very significant to me. O (∩_∩) o

Sqlbackupandftp Software Introduction to Here ~

Easy-to-use SQL Server database Automatic Backup tool SQLBACKUPANDFTP (full featured)

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.