I had issues trying to run powershell from sql agent but got the following to work:

(1) use the SqlCmd in the step.

(2) created a batch file that containted the following:

REM...

Hi Paul

Thanks for clearing that up , were using mirroring for DR right now, but i see what you mean "one size does not fill all". Thank you for your...

Hi Paul

Am new to sql replication and it sounds like replication was never meant as a DR (failover) method? I was surprised to learn that you can only replicate a...