can we have a automated script by which we automatically point the backup server incase Primary server fails and will also reconfigure the multiple nodes and will also take the backup automatically whenever there is a server failure
Simply and easily? I'd say "no". It would be better and easier to have a HA Tableau Server environment if you are really concerned about failures.
Retrieving data ...