The command is somewhat incomplete, it is missing the correct syntax near move for the log file.

It should be something more like this

USE [master]
RESTORE DATABASE [MyDB]
FROM DISK...

Whats the growth amount of the transaction log?

How many VLF's does the transaction log have?

If theres more than the usual recommended amount of VLF's (over 512) then you need to...

You would have to set the connection application intent to readwrite for the application and readonly for SSRS and ensure you have the proper read only routing setup in the...

Well you could just break it and have a 1 node AOAG cluster that way you dont have to mess around in DNS.  We all know every trouble starts with...

Also as a side note I would recommend reading up on the BBCodes and extra formatting here to help people out and readily consumable data, you did a great job...

So if I understood right, a script to run on a Saturday, to update fields for the next Mon-Fri?

If so you need to work out the "next monday" and use...

Have you checked the default trace to see if anything its being logged as to what is removing it?

Cant fully remember if replication is logged to the default trace but...

You will need to summarise the transfers and sales before joining them, the duplicate lines for each transfer and sale is the issue here as the join is producing a...

For the CR/LF you will need to do a character number replacement on a CHAR(10) CHAR(13) style

Something like the following

REPLACE(<My String With a CR LF>, CHAR(10)+CHAR(13),'_')

Or maybe as its a...

Maybe you could post a small diagram on what you want the build to look like, you know what they say, a picture says a 1000 words.

But I have to...

Key words to look up are

CREATE ROLE,

CREATE ROLE <rolename>

GRANT,

GRANT <permission> ON <object> TO <role/user>

ALTER ROLE

ALTER ROLE <rolename> ADD MEMBER <user>

For reading...

You will need to reinstall SQL as a true FCI so best to start from scratch.

With 2 existing standalone instances I would be looking to do a AOAG instead of...

Quest/ApexSQL Data Diff also as a tool to do data comparison as well was Red-Gate Data Compare already mentioned

Server time can be different from client time.  GETDATE() returns the server time, not what you see on your client.

You will need to ensure that your servers are set in...

SQL authentication or Windows authentication?

Your Azure subscription is tied to your Azure AD/On-Prem synced service for AD auth etc to do Windows?

If your integrating with AzureAD you want to look...