If the only way is from AWS for a merge replication  "One on 2019 for the distributor, one of 2008R2 for the subscriber."

Then we would have to look at other...

Thanks for that !

Although both solutions don't seem possible in our environment are on at the moment

I will try the backward merge solution and see if that works where the...

Thank you for the tips and it's the first time we try something like this.

The main goal with this setup would be temporary just to keep both versions of databases...

• This reply was modified 1 year, 11 months ago by  johnnyrmtl.

Just a note if not clear as i do get past the login screen up to this point when trying to browse the publications

• This reply was modified 1 year, 11 months ago by  johnnyrmtl.

That is indeed what I think so not sure what's going on,

Let me get more details of what's going on

I hear that auto-scaling will make the storage grow regardless of the setting ,is this true ?

Hello,

Thanks for replying...

I am new to AWS and did not set up the instance, the problem is that when the TEMPDB grows even though the existing files are capped (...

thanks for that !

I am at a loss at how i can fix this without having too much experience with 2005 and reporting services and I have tried all options...

hello again... it seems that our sysdamin is having some difficulty on the steps to set up this windows cluster

Would there be some detailed steps doc here for Windows 2016...

Perfect thank you ! will report back on how it goes

thank you for the tips

so just install another standalone on the 2nd node and take it from there then after clustering the windows nodes?

thank you all for the tips

Will see with the other options listed above

All is working !!!!

Thank you !

Thank you very much for your help and tips... Much appreciated

Will report back if all works

Do I need to restart sql services?

Or can do on the fly