Thank you Brian very much. Management is aware of the additional cost we have to pay for SSRS Enterprise licensing on that standalone box

Thank you Jeffrey, sorry I wasn't clear.

I was challenged by asking to fulfill the requirement to add an availability group to the existing 2 node FCI cluster.

So from what I...

Thank you HandyD

Thank you DesNorton

Thank you DesNorton, sorry I wasn't clear, but it is not exactly what I need.
Based on the TableB you populated, the final TableB  layout should looks like below:
CREATE TABLE #TableB...

Thank you Steve, It worked out pretty well!

Anyone?

Thank you Steve and Mike,
Steve,
What do you mean by "and the fail-over can be automated (which works very well)."
Can you please elaborate on that..

Thanks again EdVassie,
We don't have SLA at the moment( should have it around the New Year) .
Based on review of a number of articles online ( and a...

Thanks EdVassie, DinoRS, Sue_H and Nassan.
What about Sync vs Async? Does anyone have a good comparison of Sync vs Async Replication, as I am thinking about using Async Replication...

Thank you, we are using SS Enterprise 2016. We need to ensure that in the event of the down time, database(s) will become available on the other node or hot...

Understood, but for me, as long as create date from running DIR..... command equal to the timestamp from file name is equal means that file is not copied. When they...

If you dump results of DIR PATH /S /OD to the table and then query that table, then the first chars for each row is the date...

Thank you Jeff for all your suggestions, but looks like using DIR PATH /S /OD and some additional parsing after that may help me solve the issue in someway.

Thank you Jeff, I cannot rename files on Server1 due to some logic, presented only on Server2

I am inserting the results of xp_cmdshell 'DIR /B PATH' to the table and...