good luck

http://sqlarchive.blogspot.ca/2016/04/transactional-replication-subscription.html

why power shell, why not T-sql?

https://social.technet.microsoft.com/wiki/contents/articles/34552.sql-how-to-refresh-multiple-sql-databases-with-powershell.aspx

I use this, works all the time

declare @cmd varchar(max)
declare @cmd_suspend varchar(max)
declare @cmd_resume varchar(max)
declare c1 cursor read_only for
select 'ALTER DATABASE ['+DB_name(database_id)+'] SET HADR...

Since trace has more information as to who,where,when I have created a job called 'DBA - Notify System Changes'  with the code below, Also I am using Alert to detect...

umm... here are other two methods

-- get it from default trace
DECLARE @trc_path VARCHAR(500)
SELECT @trc_path=CONVERT(VARCHAR(500),value) FROM fn_trace_getinfo(DEFAULT)
WHERE property=2

print @trc_path
SELECT TEXTData,HostName,ApplicationName,DatabaseName,LoginName,SPID,StartTime,EventSequence
FROM fn_trace_gettable(@trc_path,1) fn

That depends on how you connect extra NIC, I had extra NIC with direct cable connection to backup server and the results were amazing. 

I been using striped backups...

I would never shrink data-files (https://littlekendra.com/2016/11/08/shrinking-sql-server-data-files-best-practices-and-why-it-sucks/ ), log files however a different story.

I use output of following to shrink the databases
(Just make sure you have auto...

you can use the following, no matter what you do, it is going to take time to transfer file over wire.  you may want to use with compression, in addition...

umm.... how about that?  -- this will not commit transactions but will not failover until all the transactions are committed or rolled back

if not exists (
    SELECT...

you can issue checkpoint command to ensure all the dirty pages are  written before performing fail-over.

checkpoint
go
alter availability group [myag] failover
go

I think you need to restore database from pre-depolyment backup.

I usually use the script to generate restore commands and run "restore database <dbname>" command in the end to recover the database, it makes it much easier. 

--...

I never used it, you can try and let us know. 

https://www.eversql.com/

try this

sp_configure 'xp_cmdshell',1 -- you need this to map network drive
reconfigure
go
exec xp_cmdshell 'net use x:\\server\share /user:DOMAIN\DBRestore_svc password' --map thur sql so drive is not...

are you able to map the drive ?

net use x:\\server\share /user:DOMAIN\DBRestore_svc password