Changes a database generation number in the Replication Server to prevent the application of transactions in the DSI stable queue after a replicate database is restored.
sysadmin set_dsi_generation, gen_number, primary_data_server, primary_database, replicate_data_server, replicate_database
The new generation number of the database. The number is an integer between 0 and 65,535.
The name of the data server at the primary site.
The name of the primary database.
The name of the replicate data server.
The name of the replicate database.
Sets new DSI generation number to 105. The previous number was 104 or less.
sysadmin set_dsi_generation 105 NY_DS, ny_db, SF_DS, sf_db
Use sysadmin set_dsi_generation during the recovery of a database dump. Changing the generation number except during recovery may cause incorrect data at replicate databases.
See Chapter 16, “Replication System Recovery,” in the Replication Server Administration Guide for a complete description of the recovery procedure.
sysadmin set_dsi_generation requires “sa” permission.
admin get_generation, configure connection, dbcc dbrepair, dbcc settrunc, rebuild queues
