You are here

SQL Server Backup Topics

SQL Server Backup v12

View Screenshot
( 2018.12.16 update )

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

Walk-through 6 : Using command line to run a job (for v7)

If you plan to integrate SQL Server Backup to other production batch jobs , you can use command line to start a pre-defined job. If your SQL Server Backup is early than version , please download a latest one to do that.

The command line format as following:

{installation directory}cmdrun.exe [REPORT LEVEL]

Description :
The cmdrun send a run job command to Backup Agent , just like you do it on GUI. cmdrun.exe will not exit until the job finishes.

SQL Server Backup Walkthroughs

Following walkthroughs introduce the important areas of the SQL Server Backup. Each walkthrough gives step-by-step instructions for common scenarios, which makes them a good place to start learning about the product or a particular feature area.


To provide a hands-on introduction to the numerous major features of SQL Server Backup in a clear and ordered manner , we use the professional edition and install it on the same machine as SQL Server.

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.

Screenshot of SQL Server Backup

1 . SQL Server Backup manager window


2 . Select database for backup job

Subscribe to RSS - SQL Server Backup Topics