Prepare for Nonatomic Bulk Materialization

The primary table exists and contains data.

You have a user ID with ownership or select privilege on the primary table (or a column to be replicated in the primary table).

The replicate table exists and contains the appropriate columns.

You successfully configured every Replication Server in your replication system.

You created the replication definition correctly at the primary Replication Server.

You successfully created the Replication Agent transaction log in the primary database.

You marked and enabled replication for the primary table in the primary database.

You started the Replication Agent instance and put it in the Replicating state.