Thanks SSCommitted, one last thing to ask... has anyone ever installed multiple instances on 1 cluster, example:

All one Server

Server1
InstanceA
InstanceB
InstanceB

And I am...

Ok so to make things easier, and we tested, and worked beautifully, we went with mirroring, with this solution which is similar to log shipping, so big thanks SSChampion for...

Gotya thanks, I will try that out, thanks again 🙂

Hey SSChampion, thanks for the response, ya 2008 is the primary and the 2014 is the secondary, so leave it as restore mode... with recovery, no recovery? I tried it...

YOU SIR!!! Are you genius! i replaced -U and -P with -E like you said, THEN BAM!! WORKED... OH SO BEAUTIFUL 🙂

All good, i sadly didnt mention how it was executed, this is in a SQL agent Job that would be executed once a week, ideally.

Hey sgmunson, 
yes I definitely made sure of that, i made sure to change to username and password and to use a domain account only, we use windows authentication only...

Awesome big thanks, i am soooo close, i am not sure its on my end, or maybe something else, but its saying:

Executing Script: "\\ServerB\Results\Test.sql" Sqlcmd: Error: Microsoft ODBC Driver...

Ok quick update, i further researched the error, it did recommend i use and stick with the SA, but make sure the sql service account has access to the folder,...

YAY found the problem, after much time and pulling out my hair (Had to do a trump aka come over to cover the bald spot that hair use to reside)....

I am sorry, me = idiot, it does work, and it did spit out the sql scripts, BIG thanks so now all i have to do is like you said,...

cool, but when you say "it should have an output a list of filenames" it didnt, instead it just returned to command prompt, did it output to file? what directory?

ok i think that worked, it came back to command prompt, thats good right? sorry me = idiot 😛

cool thanks for your input, when i run in command prompt:

c:\users\mypc>FOR /f %%i IN ('\\ServerB\Results\*.Sql /B') do @ECHO %%i

i get: "%%i was unexpected at this time"

Hey sgmunson, thanks for the reply, as for the sql agent job, its running under SA, though maybe i should run it in a sql account that has access to...