Hello poupster2 and Beatrix,

Thanks for your answers, good to now that it will work.

My idea was to go this way, to have as less downtime as possible.

Now for production i...

Perfect, thank you so much, was exactly what i needed.

Works like a charm!

Cheers

@goher2000

Thank you very much for this reply.

I thought in this direction and alerady added new virtual nics, but was not sure if it will work this...

I used this syntax

Setup.exe /q /ACTION=rebuilddatabase VS= [RESSOURCE]

/INSTANCENAME=[INSTANCE]

/SQLSYSADMINACCOUNTS="[ACCOUNT]"

/SAPWD="[PASSWORD]" /SQLCOLLATION=[COLATION]

IT seams everything is ok.

better then reinstall 4 Instances on 4 Nodes 🙂

Thanks anyway for your reply

cheers Sam

thats the problem, the application creates the objects with "create table xyz .... on primary" hard coded

Thanks guys, that are some good points.

But the problem we have is, lots of "out of the box" applications are developed like put all the tables and indexes (on primary).

After...