Partner Login
Home Products Solutions Services Technology Partners News/Events About Us Contact
Solutions | High Performance Cluster with Back-in-Time Restoration
  High Performance Cluster with Back-in-Time Restoration

A development SQL Server cluster differs from a production SQL cluster. It requires roll back in time capability due to potential erroneous data operations by developers. All transaction replication systems including DBx™ cannot rollback in time since each replicated transaction overwrites the prior corresponding transaction history.

Using DBx™ automatic resynchronization tool, you can implement a high- performance cluster with back-in-time restoration capability. There are at least two choices.

a. Without incremental backup and restore. This configuration does not require periodic backup. It can only restore data from the latest prior resynchronization point.

b. With incremental backup on one SQL Server. This configuration requires the administrator to activate periodic incremental backup on one of the clustered SQL Servers. Restoring the entire cluster to a point-in-time position requires activating the DBx™ resynchronization tool based on the desired back-up set.