That was what I needed ... Thanks very much. Karen

Ok.. unfortunately we do not failback to the primary with data. The primary is left usable and running during the DR test and the standby is opened just for...

Could this be used for a site to site DR test where the standby database is opened with recovery for the users to test and then log shipping is rebuilt...

Further note to this.. I traced starting up the replication monitor in both prod and test. Even though I log on to SSMS with windows authentication in prod...

Thanks for getting back

The 'SQL Server Agent account' is being used in the Log Reader Agent and the SnapShot Agent under publication properties => agent security

Still trying to understand where...

Thank you for getting back.

Is there a way to verify where sa is being used in all the replication processes? Other than changing the sa password and then having them...