Recently I was asked to develop a solution by management to reinitialize a transactional replication whenever it fails using powershell. The request was made because our 3rd party vendor restores our replicated database as part of their deployment.
I understand there are different versions of SQL servers and Powershell around our server, and develop a script for all versions will be not only hard but also risky. Also reinitialize will cause the source and destination databases become unusable/locked. Is anyone aware of this type of powershell solution somewhere?