SQL Server Backup v12



View Screenshot
Walkthroughs

     SQL Server Backup is an easy to use backup and restore utility for Microsoft SQL Server 2012, 2008, 2005 backup and restore, 2000, 7.0, MSDE, WMSDE , both desktop , express and enterprise editions.

     It is able to create popular *.7z , *.zip , *.bk  backup file. You can backup easily in different backup software or management studio. (new).

     It backs up SQL Server database to a local hard disk or network storage device,and restore database with a new name or move database files to a new location , restore database to the point of failure.

     It supports data compression and encryption. It's a user-friendly wizard and flexible design enable you backup and restore SQL Server database without deep knowledge of SQL Server.
  Screenshot           Download

Why SQL Server Backup

Creates 7z, zip , .bk backups , easily use these backup in different backup software.
Ease of use yet professional step-by-step wizard interface. No DBA experience required.
Create backup for MS SQL 2015, 2012, 2008, 2005, 2000, 7.0, supports desktop , express , professional and enterprise edition.
Built-in SQL database restore function, restore multiple databases in a single job.
Supports transaction log-shipping. This feature let you copy database between servers easily.
Compress and AES 256 bits encrypt backup data on the fly, no temporary file created.
Verify backup after job, clean expired backup after job. (Since year 2005 ,v1.0)
Email confirmation after job. (Since year 2005 , v1.0)
High performance and reliable . Firstly released in 2005 and thousands of users all over the world are using this ms sql backup software.

How to start SQL Server in single-user mode?

Compare with user database , recovering master database is little bit different .

Before run master database restore job , you are required to start SQL Server running in single user mode.

To start SQL Server in single user mode , please do following :

1) Open "Control Panel->Administrative Tools->Services"

2) Mouse right click on specified SQL Server instance service and select "Properties" menu to bring up following service configuration window:

 

 

Feature of SQL Server Backup

  • Copy mode backup supported.
  • Microsoft SQL Server 2012 backup and restore supported in v10.4.0 (new).
  • All versions of Microsoft SQL Server backup and restore supports: Microsoft SQL Server 7.0, Microsoft SQL Server 2000 , Microsoft SQL Server 2005, 2008 supports, MSDE, WMSDE, SQL Server 2005, 2008, Microsoft SQL Server 2012, both desktop, express and Enterprise Edition.
  • Remote management supports.
  • Back up multiple databases in

How to restore a sql server database to a point in time?

A very good feature for ms sql server backup software is the ability to restore database to a specified point in time.

This feature is very useful in certain circumstances.

For example ,

I have a scheduled job that performs full database backup every night at 23:00 . But today , something happened , I added some records this morning , however I deleted some usefull data accidentally at 2:00 pm.

Now the problem is :

Because I did not performed any backups during the day before 2:00 pm , the most recent backup is backup created at 23:00 last night. If I use this last night backup to restore my database, I'll lost all the data added/changed in the morning , but I want to keep work of this morning.

Thanks for ms sql server point in time recovery feature , I can restore the database to the point in time prior to 14:00 . I just need to do a transaction log backup at current moment (suppose it is 15:00) , and then I create a restore job and specify the restore point in time is 14:00 (maybe 13:59 is better) , of cause I run the restore job as soon as possbile. My work prior to 14:00 today is saved.

Although the ability to restore database to point in time is very useful , not all database can be restored to a specified point in time.

To restore a database to a point in time, the database and the backup must meet the following conditions:

 

MySQL Backup v6.0.4

mysql backup screenshot

View Screenshot
( 2020.04.04 )		  

            MySQL Backup is a very easy to use backup and restore application for MySQL . It creates 7z , zip ,gz ,raw sql backup for local or remote MySQL Server's databases easily and quickly . The user-friendly and professional wizard enables you just point and click with your mouse to do backup / restore job , without writing any sql script or complicated command line . It supports data compression and encryption . It is really a must-have tool for MySQL DBA.

    Screenshot           Download
     

MySQL Backup main window

MySQL Backup main window

Click to enlarge.
 

MySQL Backup window

MySQL Backup window

Click to enlarge.
 

Send email after job
Email after job

Click to enlarge.
 

More ... ...

 
Subscribe to