If you have logshipping setup, do not add anything else to the environment which can do log backups as to do so will affect the LSN's and will break your...

May be reading this the wrong way but hopefully I got this right.

Sounds to me like you have two clusters already (say Clust1 with Srv1 and Srv2, Clust2 with...

That is where tools like Red-Gates SQL Prompt come in handy to code refactoring.

You could also look at the sys.columns or information_schema for the columns in the tables...

You have lost quorum and as such lost the cluster.  If you want to do things cleanly you will need to re-establish a quorum of some sort.

If the...

Will Fact once loaded from stage using the 4 day method be a full load of data as like stage.  So once the process is complete both stage and fact...

Not by any chance using copy only log backups or someone toggled the default parameter value for it in the Ola script?  Just started at a place where they have had...

You will just need to add the SQL Agent account access to the server and database on the other side of the link.

Alternatively you can modify the link...

What is the configuration of your TempDB now?  Are all of the files from sys.database_files shown in D or E or a mixture?

If they are all in one...

Engorge

Reading between the lines, it sounds like your going to pass in a string'123456789' for example then split that into '123'  '456'  '789' and pass each into the stored proc?