When you create a standby database for an existing database that has replication definitions, missing columns may result under the following combination of circumstances:
If the existing database has a replication definition that does not include all columns in the table, and
An insert or update transaction that has not been committed is in the inbound queue, and
You create a standby database for the existing database (now the active database), after which
The transaction commits.
Although, by default, a standby database is supposed to receive all columns, at the time the transaction began, the standby database did not exist. Replication Server would have discarded values for columns not in the replication definition. If a column is not in the replication definition and the standby database allows a null value for the column, the row can be inserted into or updated in the standby database without the missing value. Otherwise, you must reconcile the databases yourself.
