How much data did you lose?
We’ll figure out how steep of a hill you have to climb by diving into the configuration and timing of your backups.
PROTECT YOUR DATA FOUNDATION
Most people know that a database needs to be backed up, but few understand that backups are not enough. Instead of a backup plan, what you really need is a recovery plan – a tested, proven plan to recover your database successfully from backups.
Imagine your database breaking right now, and consider what would happen if you DON’T have a plan in place and tested. Even if you have a simple disaster recovery plan with a backup from last night, can you afford to manually key-in all of today’s work? This assumes you have paper records to ensure you didn’t miss anything. This option is expensive and embarrassing. Don’t let this happen to you!
LEARN HOW IT WORKS
- How Disaster Recovery Plans Work
- Why Having a Disaster Recovery Plan is SO Important
- Finding the Right Solution
- Recovery Setup Options
Help me! My database needs to be safe for my business to run smoothly!
When your data is protected, this means You have peace of mind knowing that your recovery plan actually works. You know all your data assets will all play nicely with your other applications and tools. And you can focus on the bottom line of your company rather than worrying about the the lifeblood of your business — the safety and functionality of your data.
How Disaster Recovery Plans work –
Disaster strikes. How much data did you lose? We’ll figure out how steep of a hill you have to climb by diving into the configuration and timing of your backups.
As mentioned before, there are some details to this process that MUST be handled to ensure the disaster recovery plan will work as planned.
Point-in-Time Recovery. Don’t believe in time travel? With a Point-in-Time recovery solution, we can restore your database to the exact moment of the problem, provided your recovery plan is configured correctly. This means greatly minimizing loss of data, and is an ideal situation.
HA/DR. There are many other techniques and tools in addition to a traditional backup and restore to protect data. Log Shipping, Mirroring and AlwaysOn are just some of the solutions to build in semi-real-time, near-real-time or real-time data synchronization and redundancy.
Some of these options provide automatic failover so your application can seamlessly access the database from an alternate location, all without human intervention. This also gives us a chance to diagnose and correct the original problem without customers or employees even knowing that a problem exists!
We can help you, too
Why having a Disaster Recovery Plan is so important:
If your backup and recovery plans are not managed and tested, you could lose all of your data in a variety of ways –
- There could be something wrong with the backup process that prevents data from being restored in the case of a crisis. Usually this problem is discovered at a most inconvenient time.
- You could be backing up your data to the same physical piece of hardware as the original database. Hardware failure would then mean you lose both the live data and the backup.
- Your databases may be misconfigured to only backup nightly or weekly, risking many hours or days of data in the event of a disaster.
- Corruption of the database itself can also interfere with recoverability in the case of loss.
Recovery Setup Options
Log Shipping. This is like a glorified, automated backup/restore to a remote server.
Replication. This synchronizes data between one or more databases.
Mirroring. This is near-real-time data synchronization between two SQL Servers.
Clustering. Redundant SQL Server’s which share the same underlying data database/storage.
Always-On. This is a cross between Mirroring, Clustering and some additional secret sauce.
We can help you, too
SQLWatchmen provides a multi-faceted solution
We ensure the basics of your backup and recovery plan are set-up and running properly. Then we consider and recommend other methods of duplicating your data and building in redundant systems.
Each of these solutions have pluses and minuses, along with differing budget requirements. We’ll ask you the questions to help you navigate which options (or combinations) are the right fit for your budget and uptime/recovery needs.