You might get lucky and just need to apply tlog backups. Otherwise, do not take a full backup on the secondary server, which is now a primary replica. Take a differential...

It seems you are on SQL Server 2012 or higher. Database Mirroring is not an option.

That said, just join the DR node to the cluster. Then weigh the...

A recursive CTE that looks for the first space in reverse order I suppose.

Yes, it is technically feasible. It seems as if you are setting up D/R or consolidating databases. As long as Server C has enough resources it is more than OK.

I have experienced this issue when load testing an application at a client site. We simply could not exceed 64000 concurrent users while the CPU was barely at 20%.

I have...