Controlling SQL Server Replication using Powershell RRS feed

  • Question

  • Hi,

    I have a Powershell script to refresh the databases

    My requirement: 

    I have a database which has replication in it. I used powershell to generate replication scripts and refreshes the database with another backup copy. After refreshing, I need to start the snapshot agent. 

    How do I start the snapshot agent after refresh using powershell ?

    Is it possible to monitor the replication synchronization using powershell ?

    My ultimate goal is not to use Management studio, so that I can automate the nightly refresh process using powershell itself. 

    Please advise. 

    Thursday, December 3, 2015 5:07 PM


All replies