Automatic backup tool SQLBackupAndFTP SQLSERVER database with good (fully functi
Automatic backup tool SQLBackupAndFTP SQLSERVER database with good (fully functional)
This tool is mainly automatic backup of the database, a database, backup database log reports sent to the mailbox, automatic compression backup database
Perform database backup task periodically, replace the SSMS maintenance plan, upload the database backup file to the FTP server, other network hard disk etc.
SoftwareFree of chargeAndPayTwo kinds of mode, but I thinkThe free versionFunction is sufficient
Support the SQLSERVER version: SQLSERVER2000, SQLSERVER2005, SQLSERVER2008, SQLSERVER2008 R2, SQLSERVER2012
When your computer is especially useful when the SQL Server Express 2005 and SQL Server Express version 2008
Because there is no plan to maintain SQLSERVER Express version, use SQLBackupAndFTP to solve this problem
This tool also has a version of MYSQL
MYSQL version download address:
SQLSERVER Azure special edition download: http://files.cnblogs.com/lyhabc/SqlBakSetupAzure.rar
The installation path: C:\Program Files\Pranas.NET\SQLBackupAndFTP
The installation directory mainly are DLL
SQLBackupAndFTP will create a new Windows service, used to regularly back up the database, replace the SSMS maintenance plan,
Database backup software developed by our company is also using the Windows services approach to timing backup of database, the principle of the software about
See these pictures, I believe that want to crack the software people ready to make trouble, but best not to crack, show some respect.
We use the free version on the line, it is best not to break his payment function
About Xceed Zip for.NET components:
Database connection set first
Check backup database
Set up a mail, the backup reports sent to the mailbox
Set the timing task, you can set the full backup, differential backup, transaction log backup,
Also can be set using a system task plan or use the software to run the Windows service to run timing task
The software itself also presupposes some timing options, click with the mouse can be used.
Settings backup options, including a large database for temporary file storage path, compress backup options, whether to check the backup files, backup database log path, encrypted backup file (fee)
I took the path database backup log and a large database of temporary files are set in D:\MSSQL\Databackup
After setting the backup path above also need to return to the main interface backup path set, the backup database files can be uploaded to the FTP servers, DROPBOX, SKYDRIVE (to pay).
I put the backup file in the backup database and log the same path D:\MSSQL\Databackup
The software also can be set to automatically remove the long ago backup files, can also backup to remote path, NAS storage,
If the network path, click on the “ Test” button to test whether or not connected
All settings can be saved after the configuration, when reinstall the software, or change the machine will no longer set
Export configuration file
Setup time can click on “ run now” button to manually perform a backup, later will be in accordance with the timing task settings in the settings program to perform a database backup operation.
Open the mailbox to see the mail
In the path can see the log and is compressed backup file
You can see the backup file size for the 5.1MB is 886KB, after compression, the compression ratio is high.
A key to restore the database
Click the restore button
Select the database backup file path
If the database is in use, he will ask you whether to terminate all the process database
Reduction of success
The main functional limitation
Timing task supports only 2 database, but these functional limitations for me had little effect on o(∩_∩)o
The SQLBackupAndFTP software is introduced here.~
If have a wrong place, welcome everybody clap brick o(∩_∩)o
Posted by Lennon at November 23, 2013 - 4:32 PM