Tip

Data vaulting SQL Server databases

Barrie Sosinsky, Contributor

SQL Server administrators pay a lot of attention to backups. When data gets corrupted or when hardware fails, at least there are those backups to fall back on. But if your entire data center burns down, your backups are gone. If you are in a large organization, perhaps you have the benefit of failing over to another site locally, over fiber optic cable across a Metropolitan Wide Area Network (MWAN) or, less effectively, over longer distances. Another, more affordable solution is called data vaulting.

Generally, an outside company performs data vaulting and creates a copy of your database off site. Sometimes the original data is copied at your location, then moved to the location of the data vault, where it is reconnected across slower WAN links and resynchronized. The process isn't all that different from creating a branch office with a local copy. The data is off site, current and protected.

Next, the data-vaulting software creates a link that captures your database transactions as they occur. The link is slow but sufficient enough to capture new data, and the vaulting service is never very far behind having an up-to-date snapshot of your data.

Good data-vaulting solutions work on live SQL Server databases, not on a BCV (business continuance volume -- what EMC Corp. calls a mirrored clone of data) that has been disconnected from the database management system (DBMS). That is, data vaulting should be doing hot backups of your data, which is not an easy

    Requires Free Membership to View

thing to do.

Although you can buy vaulting software for SQL Server, which is essentially modified backup software (e.g., CommVault Systems Inc.), there are some strong advantages to using an outside service provider to perform the vaulting service: mainly that their copy is not only redundant but independent as well. Also, a data-vaulting company specializes in this application and will have more experience and specialized equipment. Chances are they will check the data set more carefully than an operational administrator would.

A number of companies are in the data-vaulting market, including Allegra Systems Inc., AmeriVault, @Backup, DataAssure, EVault Inc., Pro-Softnet Corp (iBackup), IBM, LiveVault Corp., Global Data Vault Inc., Storagepipe Solutions Inc., SwapDrive Inc. and others. LiveVault InSync Corp. holds some specific patents in backing up active SQL databases that I liked. My advice is to try to use a local or regional service provider as they are likely to be faster to respond to your needs for recovery.

Editor's Note: If you would like to receive similar tips on SQL Server administration and development, be sure to subscribe to the SQL Server Adviser newsletter. Sign up now!


Barrie Sosinsky is president of consulting company Sosinsky and Associates, in Medfield, Mass. He has written extensively on a variety of computer topics. His company specializes in custom software (database and Web-related), training and technical documentation.

This was first published in April 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.