TSQL to determine status of subscription reinitialization

• ratbak

  Default port

  Points: 1407

  More actions

  Follow

  January 30, 2023 at 10:47 pm

  #4143467

  How do I determine the initialization status of a subscription with T-SQL -- i.e, how do I determine that initialization is still in progress applying scripts, and how can I determine that it is complete -- all scripts have been applied -- the equivalent of the "Delivered snapshot..." message in Distributor to Subscriber History in Replication Monitor Suscription details (history)?

  This seems like it should be fairly straightforward, but I haven't been able to find the solution. I find lots of references to MSReplication_monitordata.status & MSdistribution_history.runstatus, but those seems to just generally indicate status, not specifically reinitialization.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 31, 2023 at 11:10 pm

  #4143943

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.