CA XOsoft™ Replication Option for SQL (formerly CA XOsoft WANSync SQL)
CA XOsoft Replication Option for SQL is a data recovery solution that uses asynchronous real-time replication to provide cost-effective disaster recovery capabilities for Microsoft SQL on 32- and 64-bit Windows standalone and cluster servers.
CA XOsoft Replication's asynchronous SQL server replication, over LAN or WAN, of database files from a production server to one or more local or geographically distant replica servers offers rapid SQL server recovery. Integrated continuous data protection safeguards against data corruption, and completely non-disruptive automatic testing of the SQL data recovery system proactively reports on the state of the replica server environment to ensure it will operate as planned in the event of a failover.
When disaster strikes, and anything that puts a stop to your ability to do business is a disaster, it is critical that you respond urgently. Whether a flood or a blackout, or the more probable virus attack or user error, you must recovery quickly with minimal data loss or risk losing productivity, revenue, customers and opportunities, perhaps even the viability of your entire business.
CA XOsoft Replication Option for SQL software helps ensure that you are ready to respond.
The CA XOsoft Replication Option for SQL Server Data Recovery Solution
CA XOsoft Replication Option for SQL is a highly cost-effective SQL server replication software solution that protects data on your mission-critical SQL servers through a wide range of disruptions, from server failure to data corruption to the loss of an entire site.
CA XOsoft Replication Option for SQL provides:
- Asynchronous host-based software SQL server replication that transfers changes to databases as they occur to a standby replica server located locally or over the WAN
- Integrated continuous data protection (CDP) for recovery from data corrupted by virus action or user or application error
- SQL server recovery software to automatically recover your data from your replica
- Tailored support for Microsoft SQL that works out of the box
- A CDP Repository with full text searching capability give end users control to recover important data quickly without placing the burden on IT administrators
- With the new Centralized Manager you have greater operational control by allowing you to manage all your replication/failover scenario configurations for your entire environment from a single console
- Bandwidth benchmarking assessment mode allows you to estimate bandwidth requirements prior to the deployment of any replication scenario. This gives you greater cost control by knowing exactly what your requirements are so that you can purchase only the bandwidth you need to meet your business needs
- Unique ease of installation with no application or user downtime, automated remote installation, and wizard-driven creation of new SQL data recovery scenarios
- Assessment mode measures exact change rate during evaluation to aid in estimating bandwidth requirements
In addition, for compliance and testing purposes, the CA XOsoft™ Assured Recovery option works in conjunction with the CA XOsoft Replication Option for SQL by enabling a full test of the recoverability of your data on a replica system. This is done by actually starting up SQL services on the replica and performing whatever operations are required to verify the integrity of the data, including updating database records, without any disruption to or gap in protection of the production server.
Other Resources
Learn more about our SQL server replication software by downloading a trial evaluation of our production SQL data recovery software or contact us for information related to your specific SQL server replication and SQL data recovery software needs. Our white papers will help to complete your business continuity / high availability research.
Be sure to view our library of recorded webcasts and demos pertaining to our SQL high availability automatic failover solution.
To take your SQL data recovery solution to the next level with monitoring and fully automated failover and failback, consider CA XOsoft™ High Availability (formerly CA XOsoft WANSyncHA), CA XOsoft's solution for true continuous application availability.
Frequently Asked Questions
Benefits of CA XOsoft Replication Option for SQL Server Replication for SQL Data Recovery
The CA XOsoft Replication Option for SQL data recovery solution delivers significant benefits that enable reduced cost and complexity, significantly broader and deeper protection against a wide variety of potential disruptions, and support that allows your business to become much more proactive in handling crisis situations. Major benefits of the CA XOsoft Replication Option for SQL server replication software include:
A Broader Data Protection Solution for Reduced Vulnerability
Effective protection is not about having a single technology, but about layering solutions to provide protection against the full range of types of failures. Our SQL server replication software works with the other critical components of your business continuity system, like clustering, backup, and snapshot technologies. CA XOsoft Replication Option for SQL helps you recover quickly, thereby maintaining continuous, reliable support for your business-critical systems.
- Real-time SQL server replication minimizes potential data loss
- Integrated continuous data protection (CDP) ensures recovery even when data becomes corrupted
- "Soft" installation allows software to be deployed without server reboots or application service restarts — which means no downtime is required to deploy the solution
Increased Productivity Through Simple and Rapid SQL Data Recovery Software
In the end, the purpose of a business continuity solution is productivity: to ensure that your people and your business are able to continue operating during and after a disaster. CA XOsoft Replication Option for SQL ensures this by enabling you to recover quickly with almost no data loss, increasing the productivity of your system administrator through ease of configuration and management and of your users through decreased application downtime.
- Simple wizard-driven SQL data recovery software minimizes downtime
- Auto-discovery of SQL components and auto-configuration of appropriate settings means minimal administrator time to configure your SQL server replication solution
- Intuitive GUI for central management of all SQL data recovery scenarios maximizes administrator productivity
- Together with CA XOsoft Assured Recovery, fully automated testing requires no administrator intervention and has no user impact, while maintaining DR protection at all times
- Support for scenario templates and support for configuration changes to multiple scenarios at once increase productivity and reduce errors
- Remote installation wizard and zero-downtime installation minimize demands on IT staff and impact on users
True SQL Data Recovery with Reduced Complexity and Cost
It is important that the expense in money and time of purchasing, installing and managing your SQL server replication solution be commensurate with the potential cost that you are protecting against. Some systems truly require the tremendous expense and complexity of the very highest-end high availability solutions, but most applications can trade a little time in recovery for dramatically reduced up front and total costs.
- Tailored support for SQL means dramatically reduced time to deploy
- Hardware and platform-independent software approach provides SQL server replication at significantly lower cost
- SQL-awareness and intuitive interface reduce administrator time for lower TCO
- Real-time asynchronous SQL server replication offers continuous protection over cost-effective networks
- Clear scenario status indicators and multiple alert paths ensure that issues requiring action are identified quickly
- Support for scenario templates and support for configuration changes to multiple scenarios at once increase productivity and reduce errors
- Single point of management and monitoring reduces management complexity
- Has no hidden costs - does not require advanced OS editions or third-party clustering solutions
- Combined with CA XOsoft Assured Recovery, allows zero-impact, fully automated testing of your SQL data recovery system
- Easily combines with virtual server technologies for reduced cost and complexity
(see our solution paper Consolidation of Disaster Recovery Replica Servers: CA XOsoft Replication and Virtual Server Technologies)
- Scheduled bandwidth throttling reduces impact on production environment
Increased Flexibility to Fit Your Needs and Environment
The CA XOsoft Replication Option for SQL server recovery solution is designed to be an out-of-the-box solution for realistic environments, but also provides support for you to customize to fit your needs.
Meeting Compliance Regulations, Testing, and Backup/Snapshot Assurance
For those industries mandated by the government or its board of directors to provide documented proof that their disaster recovery replicas will function in the event of downtime, the CA XOsoft Assured Recovery option is the solution to this previously very expensive undertaking. With CA XOsoft Replication Option for SQL combined with CA XOsoft Assured Recovery, IT professionals are provided with documented assurance that the replica is in a valid state. Once the test has verified the data to be fully consistent, appropriate staff can be alerted with the status of the test, and additional actions can be triggered on success, such as running a snapshot or a backup of the data for archiving purposes.
Frequently Asked Question
SQL Server Replication Software
The CA XOsoft Replication Option for SQL data recovery solution ensures that, should critical data be lost due to server failure or corruption, a replica set of the data on a remote server is available to retrieve the data or to take over the application on the backup server.
CA XOsoft Replication Option for SQL — An Effective SQL Data Recovery Solution
CA XOsoft Replication Option for SQL host-based asynchronous SQL server replication captures changes in real time as they happen on your production database server and transfers those changes over a LAN or WAN to a secondary replica server. The replica may be used as the source for recovering the data, or can act as a replacement server in the event the production server goes down.
Because asynchronous SQL server replication is only seconds behind the production system, the CA XOsoft Replication Option for SQL data recovery software ensures negligible potential data loss, regardless of where it is located in the world, as long as sufficient bandwidth is available, sufficient to transfer only the changes being made to information on the production server.
Of course, if a virus, user action, or software error corrupts your production information, that corruption is replicated to your standby server. Other replication products leave you with two copies of your corrupted data. However, CA XOsoft's Replication has rewind technology that is built in to ensure continuous data protection — simply use the recovery wizard to rewind to the last valid state, and recover from that point, saving potentially hours of data and recovery time.
For a fully automated failover solution, learn about CA XOsoft High Availbility Option for SQL (formerly CA XOsoft WANSyncHA SQL), which extends the CA XOsoft Replication Option for SQL data recovery solution to provide true continuous application availability.
You can find more detailed technical information on CA XOsoft Replication Option for SQL and the architecture that supports it in our accompanying advanced discussion of replication, high availability and automated testing technology. An even more in-depth discussion for those who really wish to understand the underlying technology is available in our advanced architecture overview white paper, Disaster Recovery and High Availability with CA XOsoft Replication: An Architectural Overview.
Gain a better understanding of our data protection solution and data recovery software by downloading a trial evaluation of the production version of our software. View our white papers for further resources to aid your data replication and disaster recovery research.
Be sure to view our library of recorded webcasts and demos pertaining to our SQL data recovery solution or contact us for information related to your specific data replication needs.
|
• Demos 
• White Papers 
• DR Testing Guide 
• Search 
CA XOsoft Replication
CA XOsoft High Availability
