Hi Jeffrey,

Thanks for the response.  I understand what you're saying but I have 3 questions:

<li style="list-style-type: none;">

1. How do I delete the logins and users on the secondary...

No, the better alternative is probably an availability group.

That will handle dropping and creating table.

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all...

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the time.

This...

COPY_ONLY does not work with log backups, I think.

This makes no sense. Are you sure you are connecting to the correct instance? With copy_only should work on either the primary or secondary.

No.  Look up the WITH MOVE Option

This syntax should...

If you had written the query like this the error would have appeared.

SELECT * 
FROM #CITIES C
INNER JOIN #PROVINCES P ON C.ProvinceCode - P.ProvinceCode
AND C.CityName = 'Toronto'

We had our annual DR test scheduled for last Saturday.  It was supposed to commence at 3:00 AM.

Just before 11:00 PM Friday, I get the call from our monitoring company. ...

Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for prayers...

This is incorrect:

ReportViewer1.ServerReport.ReportPath = "C:/Practice/Practice/Practice/Report2.rdl"

It needs to be the https://localhost/ReportServer/FolderName/ReportName

Secondary Replica 2 (same location Sync mode for fail over) There should be no blocking, unless you have some really bad queries as the secondaries are read-only. ...

Didn't you get some answers, and more questions, in this thread?

https://www.sqlservercentral.com/forums/topic/looking-for-sql-code

Virtual or physical, it does not matter.

All of my servers are virtualized, I have...

wait - ????...