sp_start_rep_agent includes the recovery_foreground option to print progress when RepAgent starts in recovery mode.
Starts a RepAgent thread for the specified database.
sp_start_rep_agent dbname [, {'for_recovery' | 'recovery_foreground}'[, 'connect_dataserver', 'connect_database'[, 'repserver_name', 'repserver_username', 'repserver_password']]]]]]
recovery_foreground – configures RepAgent to print the recovery progress to the client.
This configures RepAgent to print the recovery of database db2 to the client:
sp_start_rep_agent db2, recovery_foreground, ds, db1
RepAgent(5). Starting recovery, processing log records between (1018, 0) and (2355, 2). RepAgent(5). Processed 1000 log records. RepAgent(5). Processed 2000 log records. RepAgent(5). Processed 3000 log records. RepAgent(5). Processed 4000 log records. RepAgent(5). Processed 5000 log records. RepAgent(5). Processed 6000 log records. RepAgent(5). Processed 7000 log records. RepAgent(5). Processed 8000 log records. RepAgent(5). Processed 9000 log records. RepAgent(5). Processed 10000 log records. RepAgent(5). Processed 11000 log records. RepAgent(5). Processed 12000 log records. RepAgent(5). Processed 13000 log records. RepAgent(5). Processed 14000 log records. RepAgent(5). Processed 15000 log records. RepAgent(5). Processed 16000 log records. RepAgent(5). Processed 17000 log records. RepAgent(5). Processed 18000 log records. RepAgent(5). Processed 19000 log records. RepAgent(5). Processed 20000 log records. RepAgent(5). Processed 20084 log records, recovery complete. Replication Agent thread is started for database 'db2'. (return status = 0)
