Customer Testimonial
Wisconsin State Courts Office

Customer Testimonial from Wisconsin State Courts Office:

The Wisconsin Consolidated Court Automation Programs (CCAP) utilizes Sybase database servers for data warehousing and transaction processing applications to support the statewide court system for a wide variety of needs.

Last week, we experienced a massive hardware failure on one of our most critical Sybase servers. This outage took our largest live production database, all the system databases and the entire set of Sybase executable and configuration files.

The failure caused the most recent full dump of the database to become corrupt, and the Sybase server was unable to read it. And, it affected our backup systems to the extent that the newest backup available was several months old.

Finally, we could not even start the server because the configuration files and master database dump we had were mismatched, causing the server to crash.

We made every effort to find a solution with our DBA and Engineering staff as well as Sybase Technical Support. After several days, we were faced with what seemed to be a hopeless situation, until White Sands Technology entered the picture with their Data Recovery & Repair Toolset.

Using this toolset, White Sands engineers were able to perform the following "miraculous" set of tasks:

• Extract device and fragment information from the master database dump, enabling us to rebuild and reload the master device, enabling us to start the server;
• Using a proprietary utility, read the corrupted dump of our production database and rebuild the database using as much of the data as was recoverable from the dump;
• Bring the rebuilt database on-line and extract data from the tables, which we then loaded into a newly-created database. We estimate that we recovered 97% or more of the data from all tables.

In short, White Sands made the best of a disastrous situation, and we sincerely thank you for all your hard work!

Regards,

J. B.
Chief Information Officer, CCAP
Wisconsin Director of State Courts Office