If the write server of a multiplex fails in such a way that its SYSTEM dbspace and transaction log files cannot be recovered, you can use forced recovery and the sp_iqcheckdb option resetclocks as part of the process to convert one of the query servers to a write server. For the complete server conversion procedure, see the section “Replacing write servers” in Chapter 14, “Backup and Data Recovery” of the Sybase IQ System Administration Guide.
