Paragon Backup for Microsoft SQL Server

Why data protection?

Even if you don’t worry too much

In a nutshell, data protection is how technical data security maps to your business. It’s all about safeguarding your data from corruption, compromise, and loss.

Adequate protection covers all:

business information for people to keep doing business as usual;
technical data for normal operation of systems and services;
historical records for business analysis and digital forensics.

Data protection is the very foundation of business continuity, disaster recovery, and regulatory compliance for businesses of all sizes and kinds. And it simply cannot be left to chance.

Why Paragon Software?

When there are so many solutions, including freeware

Truth be told, some freeware is a really good piece of software: you save upfront money – great news for you. But you need someone who really knows how to handle the database stuff every time something happens. Be that a configuration change or (knock on the wood) a disaster, which disrupts your operations. You will also be on your own with storage management, routine maintenance, and troubleshooting your problems (unless paid support is available). The rest is history.

There’re also many commercial solutions out there. The backup market is really crowded, most products are pretty on a par with one another. They all offer full and differential backups, scheduled tasks, cloud storage, granular recovery, and all that.

How is Paragon Software different?

Our product is specifically designed for SOHO and SME. It’s tailored to their typical deployment needs and uses cases and facilitates best practices, so you can always be on the safe side.

Our product is designed to help you align data protection to business strategy, whether you may want to quickly restore the last known good configuration, failover in case of accident, or manage your storages so that data retention meets your business needs and regulatory requirements.

You can do all that without calling an admin. And it’s designed with the whole “do no harm” thing. Simply put, if you can make a pie chart with Microsoft Excel, with our product you can become a data protection master in a couple of days.

Actually, there’s more. Data is not limited to SQL databases. And when it comes to compliance, everyone is concerned with GDPR today.

Contact us to learn how we can help with data protection, GDPR TOMs and the right to be forgotten.

Backup

Paragon Backup for Microsoft SQL gives you options:

back up individual databases or entire MS SQL Server instances;
run your backups manually or schedule them to ensure desired RPOs and RTOs;
create full backups with all user data and system objects or differential backups that capture changes.

You can further turn on instance protection. In this case, new databases, which you add to the protected instance, will be automatically included in your backup plan.

Backup plans Microsoft SQL

You normally don’t have to worry about transaction logs as they will be captured automatically.
With full backups you can easily restore your database in the same state as it was at the time of the backup. But they take a long time to run and lot of storage space.

On the other hand, differential backups are quick and light. But they can take much longer time to restore as the whole chain of changes should be reconstructed. The more so, if your database is heavily used and contains many transactions.

With standard backup instruments, you must decide in advance which recovery model you want. With Paragon Backup for Microsoft SQL you don’t have this inherent dilemma – you will always be able to restore everything you need.

System Requirements

Out of the box Paragon Backup for Microsoft SQL fully supports all editions of 32-/64-bit Microsoft SQL Server 2005, 2008 (2008 R2), 2012, 2014, and 2016.

If you have an older version, you can still contact us and see if we can help. We’re strongly committed to support promptly future releases of Microsoft SQL Server, and we’re happy to announce that support for MS SQL Server 2017 for Linux is already on its way.

Retention & Storages

Store your backup at:

Local storage – removable storage device attached to your computer
Shared folder – network share, NAS or SAN
Server storage – SMB file share
Cloud – public, private or hybrid: we provide plugins for popular services

Effective storage management is a key part of your backup strategy

As a rule of thumb, you use fast and expensive storage for recent backups, which should be readily available in the event you need to restore normal operation. Depending on your business, this can be from a few days to a few weeks. As the data become outdated, you can safely move them to slow and cheap storage.

Backup to local storage

You don’t want to run out of storage capacity, or you will lose continuing backup data.
When you run backups it doesn’t matter whether your storage is slow. But it all changes with restore, especially when time is of the essence.
You may need to keep some data for a good amount of time, whether for business reasons or for regulatory compliance. Accordingly, you need effective retention policies in place.

Backup to cloud storage

Manage your storages manually or on schedule
Use rules and quotas
Replicate data among your storage

System Requirements

Out of the box Paragon Backup for Microsoft SQL fully supports all editions of 32-/64-bit Microsoft SQL Server 2005, 2008 (2008 R2), 2012, 2014, and 2016.

If you have an older version, you can still contact us and see if we can help. We’re strongly committed to support promptly future releases of Microsoft SQL Server, and we’re happy to announce that support for MS SQL Server 2017 for Linux is already on its way.

Recovery

Recover with a click of a mouse:

Go back to the last known good configuration
Select an arbitrary restore point on the timeline
Choose the recovery destination

The whole point of backups is to be able to recover. You want your business to run smoothly without any interruptions or data loss.

Last known good configuration

With minor failures or errors it’s enough to quickly roll back to the last known good configuration. With Paragon Backup for Microsoft SQL any authorized user can do this with a click of mouse.

Restore point timeline

Specify a backup to restore, use a UI slider to select an arbitrary restore point on the timeline. Your data will be accurately restored to the automatically calculated nearest best point without any loss of integrity.

Decide on recovery destination

You can restore your backup to a different from original location, physical or virtual. This is useful if you want to test something, evaluate software updates before deploying to production, migrate system.

System Requirements

Out of the box Paragon Backup for Microsoft SQL fully supports all editions of 32-/64-bit Microsoft SQL Server 2005, 2008 (2008 R2), 2012, 2014, and 2016.

If you have an older version, you can still contact us and see if we can help. We’re strongly committed to support promptly future releases of Microsoft SQL Server, and we’re happy to announce that support for MS SQL Server 2017 for Linux is already on its way.