Is ServerA and ServerB that actual names of the servers?

Linked servers cannot be referenced with special characters in them unless they are enclosed in [brackets] - Ex: SELECT * FROM...

Unless you've already done it, you might need to enable the "Data Access" option as well

Re: Web Server: a web server can be used for anything and not necessarily SQL-related applications, so the reason I even mentioned this was for you to check to make...

If the web server doesn't serve any other purpose, then there should be no issues with it - good luck!

It Depends. If the app servers are going to be looking to the SQL Server for a connection you may want to put of a "sitedown" page to let...

I can only offer a simple suggestion: use a text editor capable of handling large files and do a search and replace on the carriage returns, then reimport the files...

This is a rather long time to see a checkpoint running. Is it possible something BIG happened on that particular day?

Checkpoints occur (by default) all the time and are...

This will work just fine.

Down for 24+ hours??? Wow...that's a LONG outage!

Thanks so much guys 🙂

My brain just doesn't think that way...very simplistic and I REALLY APPRECIATE IT!!!

Thanks for the advice, I will try these and monitor over the upcoming weeks

As Steve has mentioned, look at the provided article...it could help. I'd also like to ask what is the nature of the table? Does it frequently get inserted/updated or...

There is a very good write-up on this here

In this scenario Server B processes it, then passes it back to Server A

Also check thet "lock pages in memory" has been set at the OS level, if it isn't you could be constantly swapping it all out between RAM and the disk....

Actually, by default this agent is set up to retry at 1-minute intervals...